RE: Who and What is using the shared pool

From: Tim Sawmiller <sawmillert_at_state.mi.us>
Date: Fri, 25 Aug 2000 07:39:52 -0400
Message-Id: <10600.115545@fatcity.com>

You should pin anything that is loaded 10 times or more. The overhead of = loading the item, interpreting it, and especially finding a spot in the = pool for it in a busy system is quite high.

>>> P.West_at_g-icap.com 08/25/00 06:01AM >>>
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-----
Sent: 24 August 2000 20:27
To: Multiple recipients of list ORACLE-L

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

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

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.=20 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.

***************************************************************************=

--=20
Author: Philip West
INET: P.West_at_g-icap.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------