Database monitoring Checklist
I am supposed to prepare a checklist on Database monitoring.
The contents should be like this,
1. Monitoring rollback segments:
Which dynamic views I need to see, what to see and what should be the
preventive action to be taken based on the data.
2. Cache hit ratio and buffer hit ratio monitoring.
3. Archive log destination for free space.
4. Harmful table growth.
These should be sagrigated as daily/weekely/monthly tasks.
Please let me know where can I get this information.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
You can check this too
Click Here to Expand Forum to Full Width