RE: library cache pin on grant execute
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'Mark.Bobak@xxxxxxxxxxxxxxx'" <Mark.Bobak@xxxxxxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 Apr 2006 14:59:49 +0100
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@xxxxxxxxxxxxxxxxx
212.538.1143
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Bobak, Mark
Sent: Thursday, April 06, 2006 9:55 AM
To: sjaffarhussain@xxxxxxxxx; 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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."
--
//www.freelists.org/webpage/oracle-l
--
//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
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
