RE: Who and What is using the shared pool

In this case I would suggest to Lisa that she uses the reloads figure. Also that she looks at the trace files for objects that have failed to load and use that information to provide candidates for pinning. However, I would gently disagree with you that frequent loads are bad per se or that they are the best indicator of pinning candidates. I would suggest that an object that is loaded 300 times and executed 300 times might be less of a candidate for pinning that an object that has been loaded 200 times and executed 2000 times. I would argue that it is the objects executed most frequently that are the ones you really need to keep in the pool. I would welcome any other angles on this.

Have Oracle given a reason for dropping this column? Was it providing misinformation? I will have a chase around Metalink myself. Does anyone else know how to get this information. Is it a join on hash columns? I will have a play when time allows.

Phil West - Impex IT ltd
Unix Sys Admin and Oracle Financials DBA Services

all opinions are worth [at most] what you paid for them

-----Original Message-----
From: Tim Sawmiller [mailto:sawmillert_at_state.mi.us] Sent: 24 August 2000 20:27
To: Multiple recipients of list ORACLE-L Subject: Re: Who and What is using the shared pool

Actually, loading is the action you'd like to avoid. Anything being load frequently should be pinned.

-- 
Author: Tim Sawmiller
  INET: sawmillert_at_state.mi.us

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).




*******************************************************************************

The information in this Internet e-mail is confidential and may be legally privileged.  It is intended solely for the addressee.  Access to this Internet e-mail by anyone else is unauthorised and any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. 
 When addressed to our clients any opinions or advice contained in this Internet e-mail are subject to the terms and conditions expressed in any applicable documentation or market practices governing the relationship between Garban Intercapital plc and its clients.

Any views expressed in this message are those of the individual sender except where they are stated to be the views of Garban Intercapital plc.


*******************************************************************************