oracle查询锁表

set line 200

col object_name for a50

col owner for a20

SELECT *+ rule */ lpad(' ',decode(l.xidusn ,0,3,0))||l.oracle_username User_name,o.owner,o.object_name,o.object_type,s.sid,s.serial#,s.SQL_EXEC_START                              FROM v$locked_object l,dba_objects o,v$session s

WHERE l.object_id=o.object_id                                                                             AND l.session_id=s.sid

and o.object_name='ACCT_ITEM'

and o.owner='CUST'

ORDER BY o.object_id,xidusn DESC;