RE: library cache pin on grant execute

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Thu, 6 Apr 2006 10:41:09 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF270770DCF4@AABO-EXCHANGE02.bos.il.pqe>

My guess (and it's only a guess) is that the cached metadata includes the grant information. If you grant/revoke to/from an object, that metadata must change. In order to change it, an exclusive pin would be required.

--

Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled. --Richard P. Feynman, 1918-1988

-----Original Message-----

From: Baumgartel, Paul [mailto:paul.baumgartel_at_credit-suisse.com] Sent: Thursday, April 06, 2006 10:00 AM
To: Bobak, Mark; oracle-l
Subject: RE: library cache pin on grant execute

I've often wondered why grants and revokes require exclusive pins. Why would a grant have to invalidate cached metadata for the object?

Paul Baumgartel
paul.baumgartel_at_credit-suisse.com
212.538.1143

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bobak, Mark Sent: Thursday, April 06, 2006 9:55 AM
To: sjaffarhussain_at_gmail.com; oracle-l
Subject: RE: library cache pin on grant execute

 http://www.ixora.com.au/q+a/0105/04080510.htm

--

Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled. --Richard P. Feynman, 1918-1988

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of The Human Fly Sent: Thursday, April 06, 2006 9:45 AM
To: oracle-l
Subject: library cache pin on grant execute

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

--

http://www.freelists.org/webpage/oracle-l

---

---

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

---

---

--

http://www.freelists.org/webpage/oracle-l Received on Thu Apr 06 2006 - 09:41:09 CDT