SQL> select username,status from v$session where username is not null; USERNAME STATUS ------------------------------ -------- SYS ACTIVE SYS INACTIVE DEASULB INACTIVE SYS INACTIVE DEASULB INACTIVE