Number of session logged into oracle db

[nzcam]

Can anyone help me with locating the number of sessions currently logged on to an oracle instance/DB

Thanks

 

[sem]

You may investigate V$SESSION view, but some records there are internal Oracle processes or running jobs.

Regards, Dima

http://seminihin.narod.ru

 

[SantaMufasa]

Cam,

Here is my "logins.sql" script that details each connected session:

set linesize 200
set echo off
set feedback on
col oruser format a20 heading "Oracle Username"
col osuser format a12 heading "O/S Username"
col ss heading "SID/Ser#" format a12
col time heading "Logon Date/Time" format a20
col computer heading "Computer/Terminal" format a21
col program format a50 heading "Program"
col process format 999999 heading "OS|Process|ID"
select     username oruser
   ,osuser osuser
   ,decode(substr(machine,1,7),'TENFOLD',substr(machine,9),machine) computer
   ,''''||s.sid||','||s.serial#||'''' ss
   ,status
   ,process
   ,to_char(s.logon_time,'yyyy/mm/dd hh24:mi:ss') time
   ,program
from       v$session s
order by time
/
ttitle off

Let us know if this is what you wanted.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.