Hi Rajesh,

You can make use of the v$session view to find out that. Around 5
instances are used by Oracle database. The other instances will be the
onces of the users connected.

Regards
Suraj

Suraj Oliver
(91) 9980573161 - Cell
(91) 9945180789 - Cell



-----Original Message-----
From: Rajesh kalaria
[mailto:oracledba-ezmlmshield-x684660.[Email address protected]
Sent: Wednesday, August 08, 2007 6:34 PM
To: LazyDBA Discussion
Subject: How to find out how many users are connected for oracle server

Hi

I have to find out that how many users are connected at present to
oracle server. I don't have any idea about how to get that information
from which table or view.

Rajesh


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page