Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Low hit ratio, but only for indexes

Low hit ratio, but only for indexes

From: Andy <enzoweb_at_hotmail.com>
Date: 13 Jan 2002 19:59:06 -0800
Message-ID: <8d4033cd.0201131959.6be21714@posting.google.com>


I ran a query on the v$sysstat view to get these results:

NAMESPACE Hit Ratio Pin Hit Ratio Reloads --------------- ---------- ------------- ----------

SQL AREA                98            99        198
TABLE/PROCEDURE         91            93         28
BODY                    93            92          0
TRIGGER                100           100          0
INDEX                   19             3       1588
CLUSTER                 99            99          0
OBJECT                 100           100          0
PIPE                   100           100          0 

As you can see, all the values are great, apart from the INDEX figure which is terrible! Why is this, and how can I improve it?

The SHARED_POOL_SIZE is set to 600MB.

Thanks. Received on Sun Jan 13 2002 - 21:59:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US