Re: Number of Active Users inside the Database

Use this for active users. Remove status clause and see all logged on users...

set linesize 132
set pagesize 24
set feedback on
select
SADDR,
SID,
SERIAL#,
PADDR,
substr(USERNAME,1,8) "USER",
STATUS ,
SCHEMA#,
OSUSER,
PROCESS,
LOGON_TIME,
last_call_et
from v$session
where status = 'ACTIVE' and username not like 'SYS' /

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Thu, 07 Mar 2002 17:43:19 -0800

Hello List,
Just a stupid Question.
I would like to know the Number of Active Users from a Query inside the Database. Plus is it possible to know the number of allowed licence for the Oracle

Thanks for U'r Time & Interest.

Fazal

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Abul Fazal
   INET: angmokios_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may


also send the HELP command for other information (like subscribing).




MOHAMMAD RAFIQ


_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may


also send the HELP command for other information (like subscribing).