Home » RDBMS Server » Server Administration » recompile package lead to hang (11.1.0.7 windows xp)
recompile package lead to hang [message #525135] Thu, 29 September 2011 07:07 Go to next message
andy huang
Messages: 498
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?
Re: recompile package lead to hang [message #525136 is a reply to message #525135] Thu, 29 September 2011 07:18 Go to previous messageGo to next message
John Watson
Messages: 4804
Registered: January 2010
Location: Global Village
Senior Member
v$session.blocking_session will tell you who is blocking whom.
Re: recompile package lead to hang [message #525138 is a reply to message #525136] Thu, 29 September 2011 07:26 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks!
Previous Topic: Switch database from pfile to spfile.
Next Topic: ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
Goto Forum:
  


Current Time: Thu Nov 27 00:58:58 CST 2014

Total time taken to generate the page: 0.16529 seconds