RE: get hit ration

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 04 Jun 2003 13:30:07 -0800
Message-ID: <F001.005AA7DA.20030604133007@fatcity.com>

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 .  

thanks,
-ak

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Niall Litchfield
  INET: niall.litchfield_at_dial.pipex.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

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