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