http://www.orafaq.com/faq/RDBMS_Server/Internals/faq502.htm On 4/6/06, The Human Fly <sjaffarhussain@xxxxxxxxx> wrote: > > 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 > > > -- Domingo Diaz Saenz