 |
|
Oracle
Metric Library Hit Ratio
Oracle Tips by Burleson Consulting
|
The Oracle docs note: "The Library Hit Ratio
Oracle metric
is also known as the library cache hit ratio. The ratio
indicates the number of pin requests which result in pin hits. A pin
hit occurs when the SQL or PL/SQL code you wish to execute is already
in the library cache and is valid to execute.
A low library cache hit
percentage could mean SQL is prematurely aging out of the shared pool
as the shared pool may be small, or that unsharable SQL is being used.
Also compare with the soft parse ratio; if they are both low, then
investigate whether there is a parsing issue."
This, and many other Oracle performance metrics are discussed in
my book "Oracle
Tuning" by Rampant TechPress. You can buy it directly from
the publisher and save 30% at this link:
http://www.rampant-books.com/book_2005_1_awr_proactive_tuning.htm
 |
|
Need an Oracle Health Check?
- Do you have
bad performance after an upgrade?
- Need to
certify that your database follows best practices?
BC Oracle performance gurus can quickly
certify every aspect of your
Oracle database and provide a complete verification that your database
is fully optimized. |
|
|
