SELECT
DBA_USERS.USERNAME||'-->'||
DECODE(V$SESSION.USERNAME, NULL, 'NOT CONNECTED', 'CONNECTED')||'-->'||
NVL(OSUSER, '-')||'-->'||
NVL(TERMINAL,'-')||'-->'||
SUM(DECODE(V$SESSION.USERNAME, NULL, 0,1))||'-->'||v$session.status
FROM
DBA_USERS, V$SESSION
WHERE DBA_USERS.USERNAME = V$SESSION.USERNAME (+)
 AND DBA_USERS.USERNAME = 'APPOWNER'
GROUP BY
DBA_USERS.USERNAME,
DECODE(V$SESSION.USERNAME, NULL, 'NOT CONNECTED', 'CONNECTED'),
OSUSER,
TERMINAL,v$session.status
ORDER BY 1
;

DBA_USERS.USERNAME||'-->'||DECODE(V$SESSION.USERNAME,NULL,'NOT
--------------------------------------------------------------
APPOWNER-->CONNECTED-->--->--->25-->INACTIVE
APPOWNER-->CONNECTED-->Administrator-->SRIRAM7-->1-->ACTIVE
APPOWNER-->CONNECTED-->Administrator-->SRIRAM7-->2-->INACTIVE

select
       substr(a.spid,1,9) pid,
       substr(b.sid,1,5) sid,
       substr(b.serial#,1,5) ser#,
       substr(b.machine,1,20) box,
       substr(b.username,1,18) username,
--       b.server,
       substr(b.osuser,1,8) os_user,
       substr(b.program,1,30) program,b.status
from v$session b, v$process a
where
b.paddr = a.addr and b.osuser is  not null and substr(b.osuser,1,8)='Administ'
and type='USER'
order by box

PID       SID   SER#  BOX                  USERNAME           OS_USER  PROGRAM                        STATUS
--------- ----- ----- -------------------- ------------------ -------- ------------------------------ --------
1448      558   1990  PANDU\SRIRAM7    APPOWNER           Administ                                INACTIVE
856       600   2648  PANDU\SRIRAM7    APPOWNER           Administ                                INACTIVE
748       609   9368  PANDU\SRIRAM7    APPOWNER           Administ sqlplusw.exe                   INACTIVE
324       564   3601  PANDU\SRIRAM7    APPOWNER           Administ sqlplusw.exe                   INACTIVE
5648      584   5562  PANDU\SRIRAM7    APPOWNER           Administ sqlplusw.exe                   ACTIVE

5 rows selected.