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

ID :  Password : Auto  

   ȸ¿ø:0¸í / ¼Õ´Ô:1¸í
 

 

Technote

ÀÚ·á ¹× °ü¸®ÆÁ

  • DBA Notes
  • Q & A

    ºÏ¸¶Å©
  • Asktom
       (Oracle ÀÇ ´ëÇ¥ Forum)
  • Technical Bulltin(KR)
       (±â¼úÁö¿ø°Ô½ÃÆÇ)
  • Dbazine

  •  

     


     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'


      ÃßõÇϱâ ÇÁ¸°Æ®   ¸ñ·Ïº¸±â

    Copyright 1999-2025 Zeroboard

     

     
     
    [Today:5 / Total:172122]    Design by p@rk1q