Oracle have provided many performance gathering and reporting tools over the years. Originally the UTLBSTAT/UTLESTAT scripts were used to monitor performance metrics. Oracle8i introduced the Statspack functionality which[...]
Oracle maintains its own buffer cache inside the system global area (SGA) for each instance. A properly sized buffer cache can usually yield a cache hit ratio over 90%, meaning that nine requests out of ten are satisfied[...]
This query provides a list of queries (1,000 characters only) involved in full table scans. The total number of rows and blocks for each table is also displayed so that you can determine whether the full scan is degradin[...]
Here are some scripts related to Hit/Miss Ratios . Buffer Hit Ratio BUFFER HIT RATIO NOTES: Consistent Gets – The number of accesses made to the block buffer to retrieve data in a consistent mode. DB Blk Gets &#[...]
This page is an introduction to my blog, which is dedicated to Oracle data base performance management.
I found over the years sharing knowledge to be an invaluable tool in assisting me in my various consulting assignments. Spending most of my time in capacity planning, tuning, application sizing and performance management, I thought it might be [...]
dba Ask TEM Dba
(0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5)