Re: monitoring cache hit rate from logs

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Apr 2006 16:23:05 -0700
Message-ID: <1144711385.144423.306350@v46g2000cwv.googlegroups.com>

ton, the buffer cache hit ratio is often not a very useful indicator for database performance since it can be misleading even in an OLTP environment. A high ratio can mask performance problems. Still there can be value in tracking the ratio over time. A sudden radical change can alert you to a change in application behavior.

The performance and tuning manual covers many database performance monitoring tasks.

The EM product provides one interface you can use and several third party database monitoring products are available but I like plan old SQLPlus.

With version 10g Oracle automatically tracks certain key statistics for a limited period of time in the AWR.

HTH -- Mark D Powell -- Received on Mon Apr 10 2006 - 18:23:05 CDT