Re: Pinned Packages

From: Randall Roberts <randall_at_filer.org.nospam>
Date: Thu, 31 May 2001 21:45:22 -0700
Message-ID: <3b17231a_1@news.pcmagic.net>

SELECT *
FROM v$db_object_cache
WHERE (type='PACKAGE' OR type = 'PACKAGE BODY') AND kept = 'YES';

Best!

Randall

<peter.mckenzie_at_health.wa.gov.au> wrote in message news:9f6s2l$qsd$1_at_news.netmar.com...
>
> Can some good person please tell me how to find out which packages are
pinned
> ? Thanks.
>
>
>
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
eb -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+
groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
> made through NewsOne.Net violate posting guidelines, email
abuse_at_newsone.net Received on Thu May 31 2001 - 23:45:22 CDT