SCRIPT TO CHECK THE CONCURRENT USERS IN ORACLE:

 Script to check the concurrent users


set linesize 90
set pagesize 60
COLUMN SU FORMAT A8 HEADING 'ORACLE|USER ID' JUSTIFY LEFT
COLUMN OSU FORMAT A8 HEADING 'SYSTEM|USER ID' JUSTIFY LEFT
COLUMN STAT FORMAT A8 HEADING 'SESSION|STATUS' JUSTIFY LEFT
COLUMN SSID FORMAT 999999 HEADING 'ORACLE|SESSION|ID' JUSTIFY RIGHT
COLUMN SSER FORMAT 999999 HEADING 'ORACLE|SERIAL|NO' JUSTIFY RIGHT
COLUMN SPID FORMAT A9 HEADING 'ORACLE|SESSION|ID' JUSTIFY RIGHT
COLUMN TXT FORMAT A25 HEADING 'CURRENT STATEMENT' JUSTIFY CENTER WORD
COLUMN LOGTIME FORMAT A10 HEADING 'LOGIN|TIME' JUSTIFY RIGHT

SELECT
S.USERNAME SU,
S.OSUSER OSU,
to_char(S.LOGON_TIME,'MM-DD-YYYY HH24:MI:SS') LOGTIME,
S.STATUS STAT,
S.SID SSID,
S.SERIAL# SSER,
LPAD(P.SPID,9) SPID,
SUBSTR(SA.SQL_TEXT,1,540) TXT
FROM V$PROCESS P,
V$SESSION S,
V$SQLAREA SA
WHERE P.ADDR=S.PADDR
AND S.USERNAME IS NOT NULL
AND S.SQL_ADDRESS=SA.ADDRESS (+)
AND S.SQL_HASH_VALUE=SA.HASH_VALUE (+)
ORDER BY 1,3,6;


OUTPUT

ORACLE     SYSTEM        LOGIN SESSION  SESSION  SERIAL    SESSION
USER ID  USER ID    TIME STATUS       ID       NO         ID     CURRENT STATEMENT
-------- -------- ---------- -------- ------- ------- --------- -------------------------
VBIP1     surekha. 03-18-2013 INACTIVE       14    18283       9343
     p       10:03:43

VBIP1     ashwini. 03-18-2013 INACTIVE      197     6429       9387
     ks       10:09:51

VBIP1     pruthvi. 03-18-2013 INACTIVE       78      450      10032
     kumar       11:34:03

VBIP1     suhasini 03-18-2013 INACTIVE       13     1107      10143
     .j       11:47:46