Friday, July 11, 2008

SCRIPT:Time since last user activity in database

Time since last user activity :

select username,
floor(last_call_et / 60) " In Minutes", status

from v$session
where username is not null
order by last_call_et

No comments: