www.1q.co.kr(park1q.com)

ID :  Password : Auto  

   회원:0명 / 손님:0명
 

 

Technote

자료 및 관리팁

  • DBA Notes
  • Q & A

    북마크
  • Asktom
       (Oracle 의 대표 Forum)
  • Technical Bulltin(KR)
       (기술지원게시판)
  • Dbazine

  •  

     


     session.sql
    park1q  2009-06-12 18:31:00, 조회 : 3,315, 추천 : 1019

    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'


      추천하기 프린트   목록보기

    Copyright 1999-2018 Zeroboard

     

     
     
    [Today:7 / Total:155941]    Design by p@rk1q