|
|
||
サイトメニュー |
SELECT SID,USERNAME,STATUS,OSUSER,MACHINE,SQL_TEXT FROM V$SQLAREA,V$SESSION WHERE V$SQLAREA.ADDRESS(+)=V$SESSION.PREV_SQL_ADDR ORDER BY DECODE(AUDSID,USERENV('SESSIONID'),1,0),MACHINE,OSUSER,LOGON_TIME SELECT A.SID, C.USERNAME, C.OSUSER, FROM V$LOCK A, SYS.OBJ$ B1, SYS.USER$ B2, V$SESSION C WHERE A.ID1 = B1.OBJ#(+) AND B1.OWNER# = B2.USER#(+) AND A.SID = C.SID AND C.TYPE = 'USER' |