Home » SQL & PL/SQL » SQL & PL/SQL » How can i pass the number of users who are connected in the database
How can i pass the number of users who are connected in the database [message #36776] Wed, 19 December 2001 23:25 Go to next message
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
.


----------------------------------------------------------------------
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 Go to previous message
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.

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


Current Time: Tue Aug 11 23:29:33 CDT 2020