SQL>
SQL> select username, sid, serial#, process, status
2 from v$session
3 where username is not null
4 /
USERNAME SID SERIAL# PROCESS STATUS
------------------------------ ---------- ---------- ------------ --------
RNTSOFT 32 1171 1624:1144 ACTIVE
SQL>