Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Displaying connected users
Hi,
I am using the following select to display connected users:
select username,osuser,process, program from v_$session where username is not NULL
This works fine except that it also displays this active sqlplus session. How can I display all the connected users except the session that displays it?
Thanks in advance!
Naru Mangalath Received on Wed May 08 2002 - 23:17:10 CDT