Low INDEX get hit ratio from v$librarycache

From: Kumanan Balasundaram <kumanan.balasundaram_at_qxl.com>
Date: Tue, 05 Jun 2001 11:46:12 -0700
Message-ID: <F001.0031C986.20010605113528@fatcity.com>

I get worrying figure for one of our production systems for INDEX hits from shared pool.

I have seen others complaining about this as well. What is the importance of this value anyway? What hit ratio can be taken as acceptable?

NAMESPACE % gethitratio % pinhitratio RELOADS INVALIDATIONS PINS

SQL AREA                95              100     677     5238    402955680
TABLE/PROCEDURE 99              100     17      0       803751
BODY                    100             100     0       0       157694
TRIGGER         100             100     0       0       164470
INDEX                   14              14      0       0       42
CLUSTER         100             99      0       0       1219
OBJECT          100             100     0       0       0
PIPE                    100             100     0       0       0

Thanks

Kumanan Balasundaram
Database Administrator, IT
QXL ricardo plc
www.qxl.com
P: +44 (0)208 962 7409

> QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road,
> London W6 9DP
> Registered in England No 3430894 VAT number - GB 701 8915 43
>
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you
> received this in error, please contact the sender and delete the material
> from any computer

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify postmaster_at_qxl.com

This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kumanan Balasundaram
  INET: kumanan.balasundaram_at_qxl.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Tue Jun 05 2001 - 13:46:12 CDT