select name, etc from v$db_object_cache where kept = 'YES';


-----Original Message-----
From: Craig Richards [mailto:[Email Address Removed] Wednesday, July 31, 2002 10:24 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
Oracle LazyDBA home page