Home » SQL & PL/SQL » SQL & PL/SQL » Instance lockup on GRANT to table (Oracle 10gr2)
Instance lockup on GRANT to table [message #377383] Mon, 22 December 2008 11:39 Go to next message
MarkC
Messages: 3
Registered: December 2008
Junior Member
I've had this happen a few times, seems to always be on a table that is heavily used. Can someone explain why if I GRANT SELECT to a specific user to a table in another schema the instance will lockup for a few minutes?

Is there a recompile taking place on all dependent objects? I've been searching on the Internet and have not found any documentation on the cause. Can someone please point me in the right direction? Thanks.
Re: Instance lockup on GRANT to table [message #377385 is a reply to message #377383] Mon, 22 December 2008 12:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, invalidation of cursors and maybe other things, so reparsing, SGA management...

Regards
Michel
icon7.gif  Re: Instance lockup on GRANT to table [message #377387 is a reply to message #377385] Mon, 22 December 2008 12:24 Go to previous messageGo to next message
MarkC
Messages: 3
Registered: December 2008
Junior Member
Is there documentation on this phenomenon? I'd like to understand it.
Re: Instance lockup on GRANT to table [message #377590 is a reply to message #377383] Tue, 23 December 2008 12:25 Go to previous messageGo to next message
MarkC
Messages: 3
Registered: December 2008
Junior Member
Bueller?… Bueller?… Bueller?
Re: Instance lockup on GRANT to table [message #377591 is a reply to message #377590] Tue, 23 December 2008 12:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Question

Re: Instance lockup on GRANT to table [message #377594 is a reply to message #377591] Tue, 23 December 2008 12:49 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Michel:

A reference to Ferris Bueller's Day Off, a movie.
Previous Topic: reset sequence / insert values (merged)
Next Topic: DBMS_UTILITY.FORMAT_CALL_STACK length
Goto Forum:
  


Current Time: Sun Dec 04 02:35:23 CST 2016

Total time taken to generate the page: 0.11426 seconds