SELECT owner, object_name, oracle_username || ' (' || vs.status || ')' ora_user, os_user_name os_user, machine SYSTEM, vlo.process unix, '''' || vs.SID || ',' || vs.serial# || '''' sid_serial, vr.NAME roll_name, TO_CHAR (vs.logon_time, 'YYYY/MM/DD HH24:MI:SS') TIME FROM v$locked_object vlo, dba_objects doj, v$session vs, v$transaction vt, v$rollname vr WHERE vlo.object_id = doj.object_id AND vs.SID = vlo.session_id AND vs.taddr = vt.addr AND vt.xidusn = vr.usn ORDER BY os_user, sid_serial, object_name
No comments:
Post a Comment