Users Online
· Guests Online: 132
· Members Online: 0
· Total Members: 188
· Newest Member: meenachowdary055
· Members Online: 0
· Total Members: 188
· Newest Member: meenachowdary055
Forum Threads
Newest Threads
No Threads created
Hottest Threads
No Threads created
Latest Articles
Articles Hierarchy
Identify database idle sessions
Identify database idle sessions
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;
Comments
No Comments have been Posted.
Post Comment
Please Login to Post a Comment.