Re: Seeing what's pinned in the shared pool

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/07/10
Message-ID: <33c4ac6a.5796365@www.sigov.si>#1/1

On Thu, 10 Jul 1997 01:13:50 GMT,
granta_at_nospam.student.canberra.edu.au (Fuzzy) wrote:

>People,
>
>I'm looking for a way to see the names of the objects pinned in the
>shared pool. The doco only suggests ways to count hit ratios for
>what's there, without actually naming the objects.
>
>Any help would be much appreciated.
>

You can use supplied package DBMS_SHARED_POOL. Its procedure SIZES(minsize) will list all objects residing in shared pool that are larger than specified minimal size in kilobytes.

From SQL*Plus:

BEGIN
  DBMS_SHARED_POOL.SIZES(0);
END;
/

will list all objects (packages, functions, procedures, cursors, triggers, .....) currently held in your shared pool.

Since this procedure use DBMS_OUTPUT to display data, don't forget to set SERVEROUTPUT ON with sufficient output buffer size.

>Ciao
>Fuzzy
>:-)

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Jul 10 1997 - 00:00:00 CDT