Originally posted by pando
if you execute cablock.sql in $ORACLE_HOME/rdbms/admin it will create several views for lockers, blockers etc Which are pretty useful when you have to diagnostic locking problems
Right. Another one is catparr. It is mostly used for OPS locking but can be used otherwise.