Re: show user connections

James Chen wrote:

> Here is a newbie question:
>
> How can I show all the user connections in an Oracle database ?
>
> I am using Oracle 7.3.2.x.
>
> Thanks in advance,
>
> --
> James Chen, at Interweave Software, Inc.
> james_at_iweave.com

  select * from v$session;

--
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.