User Inactive for How Long????

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