Home » RDBMS Server » Server Administration » Can we find blocking query by tracing? (11g r2, linux)
Can we find blocking query by tracing? [message #657960] Tue, 29 November 2016 06:18 Go to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Hi Experts,

We can find blocking session and query from V$ views.

Is there any other way to find blocking query like tracing etc?

Thanks in advance.

Regards,
Qazi
Re: Can we find blocking query by tracing? [message #657961 is a reply to message #657960] Tue, 29 November 2016 06:21 Go to previous messageGo to next message
John Watson
Messages: 7607
Registered: January 2010
Location: Global Village
Senior Member
Quote:
We can find blocking session and query from V$ views.
I do not think that you can. You can identify the session, but not the query.

[Updated on: Tue, 29 November 2016 06:21]

Report message to a moderator

Re: Can we find blocking query by tracing? [message #657962 is a reply to message #657960] Tue, 29 November 2016 06:22 Go to previous messageGo to next message
gazzag
Messages: 985
Registered: November 2010
Location: Bristol, UK
Senior Member
Enterprise Manager and/or Cloud Control.
Re: Can we find blocking query by tracing? [message #657963 is a reply to message #657961] Tue, 29 November 2016 06:23 Go to previous messageGo to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Thanks Watson.

Is there any other way?

Regards,
Qazi
Re: Can we find blocking query by tracing? [message #657964 is a reply to message #657963] Tue, 29 November 2016 06:31 Go to previous message
Michel Cadot
Messages: 65831
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

There is no way to find the blocking statement, you can only get the blocking block.

Previous Topic: Java class invalid after upgrade from 10g to 11gr2
Next Topic: Oracle .trc files consuming large amounts of disc space
Goto Forum:
  


Current Time: Mon Oct 15 09:42:48 CDT 2018