Database Monitoring

Proactive Database Monitoring

Metrics are a set of statistics for certain system attributes as defined by Oracle. They are computed and stored by the AutomaticWorkload Repository, and are displayed on the All Metrics page, which is viewable by clicking All Metrics under Related Links heading on the Database Home page (and some other pages). Click on the above link to read more and to become a Oracle DBA.

Oracle Diagnosing Performance Problems

ADDM runs automatically every 30 minutes to coincide with the snapshots taken by AWR. Its output consists of a description of each problem it has identified, and a recommended action. Click on the above link to read more and to become a Oracle DBA.

Using Advisors to Optimize Performance

Advisors are powerful tools for database management. They provide specific advice on how to address key database management challenges, covering a wide range of areas including space, performance, and undo management. Click on the above link to read more and to become a Oracle DBA.

More Tutorials on Oracle dba ...

Liked it ? Want to share it ? Social Bookmarking