Re: show user connections

Here is a part of the SQL I use to do this. It is essentialy the V$process or the V$session that you have to query on in real time.

select process,sid,serial#,isuser,status,username from V$session
where TYPE not like 'BACKGROUND'
order by username,osuser;

Hope this helps,
Vikas

In article <33C575A7.7A1F_at_iweave.com>, James Chen <james_at_iweave.com> 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

-- 
----------------------------------
Vikas Gautam ,
Sequent Computer Systems,
847-318-0050