show_user.sql
Download Script
@long_date col machine for a10 select sid, logon_time, status, machine, sysdate - last_call_et / 86400 "Last-Active" from v$session where username='&username' order by logon_time /
Download Script
@long_date col machine for a10 select sid, logon_time, status, machine, sysdate - last_call_et / 86400 "Last-Active" from v$session where username='&username' order by logon_time /