http://www.ixora.com.au/q+a/0105/04080510.htm -- Mark J. Bobak Senior Oracle Architect ProQuest Information & Learning For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled. --Richard P. Feynman, 1918-1988 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of The Human Fly Sent: Thursday, April 06, 2006 9:45 AM To: oracle-l Subject: library cache pin on grant execute Hello list, When I grant execute on a function to a user, the session is wating on 'library cache pin' wait event. I have waited for 20 min. still session waits on the same wait event. Any ideas? OS : HP SUPERDOM ORACLE : 9I Rel.2 (9205) -- Best Regards, Syed Jaffar Hussain 8i,9i & 10g, OCP DBA Banque Saudi Fransi, Saudi Arabia http://jaffardba.blogspot.com/ ------------------------------------------------------------------------ ---------- "Winners don't do different things. They do things differently." -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l