Database/Oracle Database

[오라클] 현재 ACTIVE SESSION 확인 쿼리

Dong538 2022. 2. 3. 11:07

 

 -- 1. 현재 ACTIVE SESSION 확인

-- 세션 상태별, 타입별 개수 확인 
SELECT COUNT (*) total_sessions,
       COUNT (DECODE (status, 'ACTIVE', 1, NULL)) active_cnt,
       COUNT (DECODE (status, 'INACTIVE', 1, NULL)) inactive_cnt,
       COUNT (DECODE (TYPE, 'BACKGROUND', 1, NULL)) background_cnt,
       COUNT (DECODE (TYPE, 'USER', 1, NULL)) user_cnt
  FROM v$session;


select sid, serial#, machine, username, osuser, schemaname, service_name, program, last_call_et, status
from v$session
where status = 'ACTIVE'
-- and type = 'user'  -- USER프로세스만 조회 -> 주석 해제
;