Before I go and re-invent the wheel (again), does anybody have a hand script (that they're willing to share) for showing locks (and blocking locks) that utilizes the=20 CONNECT BY PRIOR clause to make it a hierarchical query? ---- Matt Adams - GE Appliances - matt.adams@xxxxxxxxxxx "Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi." - Larry Wall (creator of Perl)=20 -- //www.freelists.org/webpage/oracle-l