Re: library cache pin on grant execute

  • From: "Domingo Diaz Saenz" <domingo.diazs@xxxxxxxxx>
  • To: sjaffarhussain@xxxxxxxxx
  • Date: Thu, 6 Apr 2006 15:58:33 +0200

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

Other related posts: