[ORACLE]오라클 DB Connect 확인 쿼리

 

  
  
  SELECT  /*+ rule */ 
          s.logon_time "Connect Time"
        , s.lockwait "Lock Wait"
        , s.status "Status"
        , s.serial# "Serial#"
        , s.TYPE "Type"
        , s.username "DB User"
        , s.osuser "Client User"
        , s.server "Server"
        , s.machine "Machine"
        , s.module "Module"
        , s.terminal "Terminal"
        , s.program "Program", p.program "O.S. Program"
        , si.physical_reads "Physical Reads"
        , si.block_gets "Block Gets"
        , si.consistent_gets "Consistent Gets"
        , si.block_changes "Block Changes"
        , si.consistent_changes "Consistent Changes"
        , s.process "Process"
        , p.spid
        , p.pid
        , s.serial#
        , si.sid
        , s.sql_address "Address"
        , s.sql_hash_value "Sql Hash"
        , s.action 
FROM V$SESSION s
   , V$PROCESS p
   , SYS.V_$SESS_IO si 
WHERE s.paddr   = p.addr(+) 
  AND si.sid(+) = s.sid 
  AND s.username IS NOT NULL