Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: library cache pin on grant execute

Re: library cache pin on grant execute

From: Domingo Diaz Saenz <domingo.diazs_at_gmail.com>
Date: Thu, 6 Apr 2006 15:58:33 +0200
Message-ID: <990cd870604060658g94a5561h23c73614f62def7a@mail.gmail.com>


http://www.orafaq.com/faq/RDBMS_Server/Internals/faq502.htm

On 4/6/06, The Human Fly <sjaffarhussain_at_gmail.com> 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."
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Domingo Diaz Saenz

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 06 2006 - 08:58:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US