
|
 |

|
 session.sql
|
park1q
|
2017-07-22 18:51:18, Á¶È¸ : 3,818, Ãßõ : 1123 |

SELECT * FROM (SELECT S.USERNAME USERNAME, SI.SID SID, S.SERIAL# SERIAL, TO_NUMBER(P.SPID) SPID, S.OSUSER OSUSER, DECODE(S.COMMAND,3,'SELECT',2,'INSERT',6,'UPDATE',7,'DELETE','UNKNOWN') COMMAND , S.STATUS STATUS , SW.EVENT EVENT, S.MACHINE MACHINE, S.MODULE MODULE, S.ACTION ACTION, P.PROGRAM PROGRAM, SI.CONSISTENT_GETS + SI.BLOCK_GETS SLRS, TO_CHAR(S.LOGON_TIME,'YYYY/MM/DD HH24:MI:SS') LOGON_TIME FROM SYS.V_$SESS_IO SI, SYS.V_$SESSION S, SYS.V_$PROCESS P, SYS.V_$SESSION_WAIT SW WHERE S.USERNAME IS NOT NULL AND SI.SID(+) = S.SID AND P.ADDR(+) = S.PADDR AND SW.SID = S.SID ORDER BY 1 asc ) WHERE 1=1 and STATUS = 'ACTIVE' |
|
|
|
|
|
|