This content has been marked as final. Show 1 reply
you can use v$lock to identify locks directly:
select * FROM v$lock aa, v$lock b, v$session blocker ,v$session waiter WHERE aa.block = 1 AND b.request > 0 AND aa.id1 = b.id1 AND aa.id2 = b.id2 AND aa.sid = blocker.sid AND waiter.sid = b.sid
SagiGal wrote:Please advise if I going to turn on the script to run by 24/7, which item I need to monitor on?(eg: temp space, rollback segments etc)Nothing. you can run this query every minute! It queries the system views, which are organized by oracle continuously.