Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 'Pinned' packages in Shared Pool

Re: 'Pinned' packages in Shared Pool

From: Mark D Powell <mark.powell_at_eds.com>
Date: 20 Feb 2002 06:51:25 -0800
Message-ID: <178d2795.0202200651.2e89f475@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

Yes, look at the kept column of v$db_object_cache.

Received on Wed Feb 20 2002 - 08:51:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US