What are the responsibilities of the DBA in daily work

Master Eygle's seven tips for DBAs

What is the job responsibility of the DBA? What should the DBA do every day? How can a DBA in a stable environment grow and work?

This is a question that a lot of people have raised, I scribble, the arbitrary record of my views and suggestions for reference:

1. Real-time Monitoring database alarm log

This is a must work, and should be based on different severity levels, send different levels of alarm, timely understanding of database changes and alarms.

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

The implementation of monitoring is critical to the operation of the database, can characterize the important changes in the database statistics, and send the alarm information accordingly. So what statistics should be monitored? We can think about, for stand-alone, RAC environment is 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 your 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, can optimize the proposed optimization and adjustment recommendations

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.

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.

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/basis/