RE: get hit ration

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

-----Original Message-----

Sent: 03 June 2003 17:35
To: Multiple recipients of list ORACLE-L

found that gethitratio in v$librarycahce is very low for indexes. what
does it mean ? is there any way to improve this .

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Jun 04 2003 - 16:30:07 CDT