Is there any way I can find for how long the user has been inactive for.
The only which i can think of is to ge t its Unix process id
and do ps -ef to check the for how much time that session is sitting idle.
Try the following:
col sid format 999
col username format a10 truncated
col status format a1 truncated
col logon format a17
col idle format a9
col program format a30 truncated
to_char(logon_time,'dd-mm-yy hh:mi:ss') "LOGON",
order by last_call_et;
Thanks a lot For ur help.
Click Here to Expand Forum to Full Width