Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 'Pinned' packages in Shared Pool
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.