News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Identify database idle sessions

  • Posted by Gavin Soorma
  • On June 29, 2009
  • 0 Comments
set linesize 140
col username format a15
col idle format a15
col program format a30

PROMPT Enter the number of minutes for which the sessions should have been idle:
PROMPT

select
sid,username,status,
to_char(logon_time,'dd-mm-yy hh:mi:ss') "LOGON",
floor(last_call_et/3600)||':'||
floor(mod(last_call_et,3600)/60)||':'||
mod(mod(last_call_et,3600),60) "IDLE",
program
from
v$session
where
type='USER'
and (LAST_CALL_ET / 60) > &minutes
order by last_call_et;
 

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *