Shulou(Shulou.com)06/01 Report--

Today, I was reading teacher Gai Guoqiang's book. I saw that these were well written. They were sent out, and all the gentlemen encouraged me together.

As a dba, one should be diligent, rigorous, studious and capable of independent thinking.

What are the daily duties of DBA? What should DBA do every day?

How to grow and optimize DBA in a stable environment? This is a question that has been raised by many people. Here are the views and suggestions for reference.

1. Real-time monitoring database alarm log as a DBA, or even a technician who is data-driven with Oracle and becomes the future www.enmotech.com Eygle's DBA workbook 11 library, you must know what the alarm log is and where it is. For DBA, real-time monitoring of the alarm log of the database is a necessary work, monitoring and should be based on different severity levels, send different levels of alarm information (through e-mail, text messages), which can help us to understand the changes and anomalies of the database in time, respond in time and intervene to deal with it.

two。 The implementation of monitoring the important statistical information of the real-time monitoring database is very important for the operation of the database. We should pay close attention to the statistical information that can represent the important changes of the database, and send alarm information accordingly. So what statistics should be monitored? We should think deeply according to the conditions, for the stand-alone, RAC environment and so on are different.

3. Deploy the automatic Statspack/AWR report generation mechanism to check the AWR report of the previous day every day, be familiar with the operation of the database, and know the database like the back of your hand.

4. Optimize and be familiar with at least one Top SQL per day according to AWR or Statspack reports, know or know at least one Top SQL per day, and put forward optimization and adjustment suggestions if you can optimize. A DBA should be very familiar with and understand the SQL in a stable system, so that it is possible to make a quick judgment and response when there are performance problems in the system.

5. Deployment of a perfect monitoring and data sampling system DBA should deploy a perfect monitoring system to the database, and sample important information, and be able to generate real-time or regular graphs of important indicators of the database to show the running trend of the database.

6. A comprehensive and in-depth understanding of the application architecture without understanding the application of DBA is a hopeless DBA, and a DBA without in-depth understanding of the application is not an Expert, so we must have an in-depth understanding of the application. After the database itself has become more automated and simplified, the future DBA should continue to move towards the front end, deepen the solution to the application, and grasp and optimize the database and the overall situation from the application point of view.

7. Write system architecture, status quo, adjustment memo according to the research and understanding of the database, constantly record the status of the database, write database architecture, status and adjustment memo, do not miss any possible opportunities for optimization and improvement.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.