library cache pin on grant execute

From: The Human Fly <sjaffarhussain_at_gmail.com>
Date: Thu, 6 Apr 2006 16:44:35 +0300
Message-ID: <97b7fd2f0604060644l3b7f992dxf89e4231fcd53267@mail.gmail.com>

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 Received on Thu Apr 06 2006 - 08:44:35 CDT