Lesson 17

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.

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