OraFAQ Forum: Server Administration » recompile package lead to hang

Home » RDBMS Server » Server Administration » recompile package lead to hang (11.1.0.7 windows xp)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

recompile package lead to hang [message #525135]

Thu, 29 September 2011 07:07

andy huang
Messages: 485
Registered: July 2011

Senior Member

Dear all,
I recompile a package in a session,and found the session is hang,I know there are have others session run the package,how can i find what session run by the package?

Report message to a moderator

Re: recompile package lead to hang [message #525136 is a reply to message #525135]

Thu, 29 September 2011 07:18

John Watson
Messages: 3181
Registered: January 2010
Location: Global Village

Senior Member

v$session.blocking_session will tell you who is blocking whom.

Report message to a moderator

Re: recompile package lead to hang [message #525138 is a reply to message #525136]

Thu, 29 September 2011 07:26

andy huang
Messages: 485
Registered: July 2011

Senior Member

Thanks!

Report message to a moderator

Previous Topic:	Switch database from pfile to spfile.
Next Topic:	ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 20 06:05:59 CDT 2013

Total time taken to generate the page: 0.15643 seconds