sp_who

Hello there,

I am looking for an equivalent command of "sp_who" in ORACLE 8. I use sp_who in SQLSERVER/SYBASE to see all the logged in user.

Cheers

select username from v$session
where sid > 6;

(The sid > 6 is so you will see actual users, not Oracle processes)

cheers Steve.