SELECTb.session_idASsid,NVL(b.oracle_username,'(oracle)')ASusername,a.ownerASobject_owner,a.object_name,Decode(b.locked_mode,0,'None',1,'Null(NULL)',2,'Row-S(SS)',3,'Row-X(SX)',4,'Share(S)',5,'S/Row-X(SSX)',6,'Exclusive(X)',b.locked_mode)locked_mode,b.os_user_nameFROMdba_objectsa,v$locked_objectbWHEREa.object_id=b.object_idORDERBY1,2,3,4