OraFAQ Forum: SQL & PL/SQL » How can i pass the number of users who are connected in the database

Home » SQL & PL/SQL » SQL & PL/SQL » How can i pass the number of users who are connected in the database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can i pass the number of users who are connected in the database [message #36776]

Wed, 19 December 2001 23:25

george kampouris
Messages: 3
Registered: December 2001

Junior Member

Hello,

How can i pass the number of users who are connected in the database?
for instance select count(*) from
.

----------------------------------------------------------------------

Report message to a moderator

Re: How can i pass the number of users who are connected in the database [message #36794 is a reply to message #36776]

Thu, 20 December 2001 23:30

RajuKVG
Messages: 13
Registered: December 2001

Junior Member

Hi George,
U can get this from the v$session. just query the table and give select distinct count(*) from v$session. But u need to have read permission for this data dictionary. For which u contact u'r DBA.

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	HELP: 'table' must name a table which the user has access
Next Topic:	The ' Char in Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 20:42:47 CDT 2024