DBA's day-to-day duties--my 7-point recommendation to the DBA

What is the job responsibility of the DBA? What your DBA should do every day. How to grow and optimize DBAs in a stable environment. This is a lot of people have raised the question, below is my point of view and suggestions for reference.

1. Real-time Monitoring database alarm log

As a DBA, or even just a technician dealing with an Oracle database, you must know what the alarm log is and where.

And for DBAs, real-time monitoring of the database alarm log is required to work, monitoring and should be based on different severity levels, send different levels of alarm information (through mail, SMS), which can help us to timely understanding of the database changes and anomalies, timely response and intervene to deal with.

2. Real-time monitoring of the database important statistical information

Implementation monitoring is critical to the operation of the database, and should be highly concerned with statistics that can characterize the important changes in the database, and send warning messages accordingly. So what statistics should be monitored? We should distinguish between the conditions of in-depth thinking, for stand-alone, RAC environment, etc. are different.

3. Deployment of automated STATSPACK/AWR reporting generation mechanism

Daily Check the day before the AWR report, familiar with the operation of the database, so that the database at their fingertips.

4. Optimize and familiarize with a top SQL at least every day

According to AWR or Statspack reports, at least a day to understand or familiar with a top SQL, you can optimize the proposed optimization and adjustment recommendations. A DBA should be very familiar with and aware of the SQL in a stable system, so that it is possible to see around corners and respond quickly when performance problems occur in the system.

5. Deployment of a sound monitoring and data sampling system

The DBA should deploy a perfect monitoring system for the database, sample the important information, and generate the graph of the important indexes of the database in real time or on a regular basis to show the running trend of the database.

6. Comprehensive and in-depth understanding of the application architecture

A DBA with no knowledge of the application is not a promising DBA, and it is not expert for a DBA with an in-depth understanding of the application, so be sure to delve into the application.

After the database itself becomes more automated and simplified, the future DBA should continue to move to the front end, deepen understanding of the application, and optimize the database and the overall situation from an application perspective.

7. Writing system structure, Status quo, adjustment memo

According to the research and understanding of the database, constantly record the status of the database, write the database structure, the status quo and adjust the memo, do not miss any possible optimization and improvement opportunities.