Another Way To See Who Is Blocking

A simple and quick way to see who is producing blocks in the database is to use the query we show below. Of course, there are other ways to perform this task such as query the DBA_BLOCKERS. The next step will see the blocker process, what are it doing?

 

SELECT SID FROM V$LOCK WHERE BLOCK = 1

 

HTH – Antonio NAVARRO

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s