oracle 현재 connection 조회 쿼리
SELECT Substr(username,1,12) username,
SUBSTR(program,1,15) program,
status,
SUBSTR(To_Char(logon_time, 'day hh24:mi:ss'),1,15) logon_time,
TRUNC(last_call_et/60) idle_minutes
FROM v$session
WHERE username IS NOT NULL
AND username <> 'SYS'
And username <> 'SYSTEM';
History
Last edited on 07/05/2007 15:14 by benelog
Comments (0)