Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

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
/