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.
<FONT face=Arial color=#0000ff

size=2> 
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.
<FONT face=Arial color=#0000ff

size=2> 
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.
<FONT face=Arial color=#0000ff

size=2> 

Niall
<BLOCKQUOTE dir=ltr

style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">   

  <FONT
  face=Tahoma size=2>-----Original Message-----From: [EMAIL PROTECTED]   [mailto:[EMAIL PROTECTED] On Behalf Of AKSent: 03 June 2003   17:35To: Multiple recipients of list ORACLE-LSubject:   get hit ration
  found that gethitratio in v$librarycahce is very   low for indexes. what does it mean ? is there any way to improve this   .
   
  thanks,
  -ak Received on Thu Jun 05 2003 - 09:11:24 CDT