OraFAQ Forum: Server Administration » Can we find blocking query by tracing?

Home » RDBMS Server » Server Administration » Can we find blocking query by tracing? (11g r2, linux)

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

Can we find blocking query by tracing? [message #657960]

Tue, 29 November 2016 06:18

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

Report message to a moderator

Re: Can we find blocking query by tracing? [message #657961 is a reply to message #657960]

Tue, 29 November 2016 06:21

John Watson
Messages: 8994
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

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Enterprise Manager and/or Cloud Control.

Report message to a moderator

Re: Can we find blocking query by tracing? [message #657963 is a reply to message #657961]

Tue, 29 November 2016 06:23

qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan

Member

Thanks Watson.

Is there any other way?

Regards,
Qazi

Report message to a moderator

Re: Can we find blocking query by tracing? [message #657964 is a reply to message #657963]

Tue, 29 November 2016 06:31

Michel Cadot
Messages: 68773
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 02 10:10:58 CST 2026