A
library cache hit means that when parsing a statement the object definition
is already found in the cached data dictionary (likely it has been recently
used). A library cache miss means that it aint there.
Now if
you can explain to your line of business boss why you would wish to improve the
ratio of one to the other by allocating some memory that could be used for
something else to the library cache (located in the shared pool), then go right
ahead.
On the
other hand you might have a real performance problem (my report runs for 1.5
hours and it only used to run for 3 minutes), these sorts of problems
generally have a different underlying cause than finding objects in memory
rather than on disk, 80 % of the time or thereabouts its the sql, 10% or there
abouts its the data.
Niall
|
Title: Message
- get hit ration AK
- Re: get hit ration Mogens Nørgaard
- Niall Litchfield