SELECT * FROM V$DB_OBJECT_CACHE
WHERE SHARABLE_MEM > 10000
AND (TYPE='PACKAGE' OR TYPE = 'PACKAGE BODY' OR
TYPE = 'FUNCTION' OR TYPE = 'PROCEDURE')
AND KEPT = 'YES';

You can take out the size requirement if you wish.. Regards

-----Original Message-----
From: Craig Richards [mailto:[Email Address Removed] Wednesday, July 31, 2002 11:23 AM
To: LazyDBA.com Discussion
Subject: What is pinned




How you can you find out what is pinned, triggers, packages etc etc

Cheers
Craig

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
***Note:The information contained in this message may be privileged and
confidential and protected from disclosure. If the reader of this message is
not the intended recipient, or an employee or agent responsible for
delivering this message to the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this communication is
strictly prohibited. If you have received this communication in error,
please notify the Sender immediately by replying to the message and deleting
it from your computer. Thank you. Premier Inc.
Oracle LazyDBA home page