-
Hi,
Is there any way I can find for how long the user has been inactive for.
Thanks
Anurag
-
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
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'
order by last_call_et;
Dragon
-
Thanks a lot For ur help.
It worked.
Anurag
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|