SCRIPT:To Check all Connected Users

Show all connected users:

select username, sid ',' serial# "ID",
status,last_call_et "Last Activity"
from v$session
where username is not null
order by status desc, last_call_et desc