select V$SESSION.sid, v$session.SERIAL#, v$process.spid, rtrim(object_type) object_type, rtrim(owner) || '.' || object_name object_name, decode(lmode,0,'None',1, 'Null', 2, 'Row-S', 3,'Row-X', 4,'Share', 5,'S/Row-X',6,'Exclusive','Unknown') LockMode, decode(request,0,'None',1,'Null', 2,'Row-S',3,'Row-X',4,'Share',5,'S/Row-X', 6,'Exclusive','Unknown') RequestMode, ctime, block b, v$session.username, MACHINE, MODULE, A......
阅读全文