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
Printable View
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.