See all locks in the db, across sessions?

[chopsuey]

Hello, I am evaluating this product to see if it provides all of the features I currently use in Toad. In the Sessions window, I am trying to figure out a way to see locks across all sessions. Many times a developer will call and ask if there is a blocking lock. In Toad, I can see all locks in the system in one window. In another window I can see which locks are blocking other users. With PL/SQL Developer I can only see the locks per the selected user. Am I missing something?

Thank you,
Sue

 

[Marco Kalter]

There is no standard functionality for this. You would need to create your own report or query.

 

[chopsuey]

Hi Marco, thank you. Is there an add on that supports DBA tasks? I'm not a DBA so I don't need very advanced tools, but I do need to be able to kill the blocking locks in the system without having to click through every user to see which one has locks. I would think this would be a common request, no?

If anyone has a script that will return all of the locks and blocking locks in the system (not per user) I would very much appreciate it, if you would post or email to me.

Thanks again,
Sue

 

[ScottMattes]

i'd like that too, but I'd also like queries by use for 'has these locks' and 'is blocked by these locks'.

 

[chopsuey]

Hi Scott, I agree with you. I would like to see all locks, the owner of the lock and who is blocked by the lock. When I find the query that does this I will post i here.

Thanks,
Susan

 

[D.]

Hi,

Here's something similar in this topic which may be of use.

D.

 

[ScottMattes]

thank you, it is close to what I need/want, but as my append there indicates I need one that bypasses that DBMS table