Re: 'Pinned' packages in Shared Pool

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 20 Feb 2002 06:23:05 -0800
Message-ID: <a20d28ee.0202200623.39409cb1@posting.google.com>

markg_at_mymail.tm (MarkyG) wrote in message news:<ab87195e.0202200205.6c881075_at_posting.google.com>...
> Hiya,
>
> Does anyone know how to find out the names of packages and procedures
> which have been pinned inside the shared pool?
>
> Cheers,
>
> M

set serveroutput on
exec dbms_shared_pool.sizes(<n>)
where n is in k, will show everything in the pool of <n> k and above and also show whether it is pinned

Hth

Sybrand Bakker
Senior Oracle DBA Received on Wed Feb 20 2002 - 08:23:05 CST