Header

  1. View current page

    정상혁의 수첩

Profile_img_60x60_08
195

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)

You must log in to leave a comment. Please sign in.