Database Monitoring   «Prev  Next»
Lesson 17

Database Monitoring Conclusion

You can monitor several statistics on a regular basis to ensure that Oracle is operating efficiently, that it has enough disk space available, and that it has enough memory. In this module, you learned about some of the more important things to look at. Now that you've completed this module, you should be able to do the following:
  1. Check the alert log for a database and spot potential problems
  2. Rename the alert log to get rid of old entries
  3. Monitor license usage
  4. Determine the amount of free space within a database
  5. Identify objects that may not have room to grow
  6. Measure the effectiveness of the database buffer cache by calculating the buffer cache hit ratio
  7. Measure the effectiveness of the shared pool by calculating the dictionary and library cache hit ratios
  8. Generate a statistics report by running the utlbstat.sql and utlestat.sql scripts
  9. Check for redo log buffer contention
  10. Monitor the distribution of I/O across your disks

Ongoing monitoring is an important part of managing a database. By becoming familiar with your database's operating and growth characteristics, you can keep your database purring like a well-maintained Ferrari.


In this module, you were introduced to the following terms:
  1. License high water mark
  2. Locally managed tablespace
  3. SID
In the next module, you will learn about managing the control file and setting database parameters.

Diskio Redo Contention - Quiz

Click the Quiz link below to answer a few questions about disk I/O and redo contention.
Diskio Redo Contention - Quiz