ORACLE中被锁的对象

ORACLE中被锁的对象 set linesize 999 SELECT A.OWNER, A.OBJECT_NAME, B.XIDUSN, B.XIDSLOT, B.XIDSQN, B.SESSION_ID, B.ORACLE_USERNAME, B.OS_USER_NAME, B.PROCESS, B.LOCKED_MODE, C.MACHINE, C.STATUS, C.SERVER, C.SID, C.SERIAL#, C.PROGRAM FROM ALL_OBJECTS A, V$LOCKED_OBJECT B, V$SESSION C A.OBJECT_ID = B.OBJECT_ID ) WHERE ( AND (B.PROCESS = C.PROCESS ) ORDER BY 1,2; select t2.username, t2.sid, t2.serial#, t3.object_name, t2.OSUSER, t2.MACHINE, t2.PROGRAM, t2.LOGON_TIME, t2.COMMAND, t2.LOCKWAIT, t2.SADDR, t2.PADDR, t2.TADDR, t2.SQL_ADDRESS, t1.LOCKED_MODE from v$locked_object t1, v$session t2, dba_objects t3 where t1.session_id = t2.sid and t1.object_id = t3.object_id order by t2.logon_time; SELECT r.NAME 回滚段名,s.sid SID,s.serial# Serial, s.username 用户名,s.machine 机器名, t.start_time 开始时间,t.status 状态, t.used_ublk 撤消块,USED_UREC 撤消记录, t.cr_get 一致性取,t.cr_change 一致性变化, t.log_io "逻辑I/O",t.phy_io "物理I/O", t.noundo NoUndo,g.extents Extents,substr(s.program, 1, 50) 操作程序 FROM v$session s, v$transaction t, v$rollname r,v$rollstat g WHERE t.addr = s.taddr AND t.xidusn = r.usn AND r.usn = g.usn ORDER BY t.used_ublk desc; SELECT /*+ ORDERED */ sql_text FROM v$sqltext a WHERE (a.hash_value, a.address) IN (SELECT DECODE(sql_hash_value, 0, prev_hash_value, sql_hash_value), DECODE(sql_hash_value, 0, prev_sql_addr, sql_address) FROM v$session b = '2834') /* 此处233 为SID*/ WHERE b.sid ORDER BY piece ASC;