you can query v$session as follows:
Code:
BLAE: SYS> r
1 SELECT rpad(USERNAME,15), TO_CHAR(LOGON_TIME, 'DD-MON-YYYY'), rpad(OSUSER,20),
2 rpad(module,15), RPAD(MACHINE,20), status, COUNT(*) FROM V$SESSION
3 GROUP BY USERNAME, TO_CHAR(LOGON_TIME, 'DD-MON-YYYY'), OSUSER, module, MACHINE, status
4* order by 6
RPAD(USERNAME,1 TO_CHAR(LOG RPAD(OSUSER,20) RPAD(MODULE,15) RPAD(MACHINE,20) STATUS COUNT(*)
--------------- ----------- -------------------- --------------- -------------------- -------- ----------
08-JAN-2003 SYSTEM DATABASE ACTIVE 7
SYS 15-FEB-2003 DATABASE\rgg SUNSIP.COM\SUN10 ACTIVE 1
15-FEB-2003 ACTIVE 1
26-JAN-2003 SYSTEM DATABASE ACTIVE 1
U_LMS 02-FEB-2003 jdbcuser jdbcclient INACTIVE 1
U_LMS 03-FEB-2003 jdbcuser jdbcclient INACTIVE 5
U_LMS 04-FEB-2003 jdbcuser jdbcclient INACTIVE 10
U_LMS 05-FEB-2003 jdbcuser jdbcclient INACTIVE 1
U_LMS 06-FEB-2003 jdbcuser jdbcclient INACTIVE 1
U_LMS 07-FEB-2003 jdbcuser jdbcclient INACTIVE 5
U_LMS 08-JAN-2003 jdbcuser jdbcclient INACTIVE 1
RPAD(USERNAME,1 TO_CHAR(LOG RPAD(OSUSER,20) RPAD(MODULE,15) RPAD(MACHINE,20) STATUS COUNT(*)
--------------- ----------- -------------------- --------------- -------------------- -------- ----------
U_LMS 09-FEB-2003 jdbcuser jdbcclient INACTIVE 1
U_LMS 09-JAN-2003 jdbcuser jdbcclient INACTIVE 2
U_LMS 10-FEB-2003 jdbcuser jdbcclient INACTIVE 6
U_LMS 11-FEB-2003 jdbcuser jdbcclient INACTIVE 4
U_LMS 12-FEB-2003 jdbcuser jdbcclient INACTIVE 9
U_LMS 12-JAN-2003 jdbcuser jdbcclient INACTIVE 1
U_HRIS 13-FEB-2003 jdbcuser jdbcclient INACTIVE 10
U_INTRANET 13-FEB-2003 jdbcuser jdbcclient INACTIVE 2
U_LMS 13-FEB-2003 jdbcuser jdbcclient INACTIVE 13
U_LMS 13-JAN-2003 jdbcuser jdbcclient INACTIVE 3
U_HRIS 14-FEB-2003 jdbcuser jdbcclient INACTIVE 19
RPAD(USERNAME,1 TO_CHAR(LOG RPAD(OSUSER,20) RPAD(MODULE,15) RPAD(MACHINE,20) STATUS COUNT(*)
--------------- ----------- -------------------- --------------- -------------------- -------- ----------
U_INTRANET 14-FEB-2003 jdbcuser jdbcclient INACTIVE 1
U_LMS 14-FEB-2003 jdbcuser jdbcclient INACTIVE 20
U_TIMESHEET 14-FEB-2003 jdbcuser jdbcclient INACTIVE 2
U_LMS 14-JAN-2003 jdbcuser jdbcclient INACTIVE 7
U_SECURITY 15-FEB-2003 jdbcuser jdbcclient INACTIVE 3
U_TIMESHEET 15-FEB-2003 jdbcuser jdbcclient INACTIVE 7
U_LMS 15-JAN-2003 jdbcuser jdbcclient INACTIVE 1
U_LMS 16-JAN-2003 jdbcuser jdbcclient INACTIVE 1
U_LMS 17-JAN-2003 jdbcuser jdbcclient INACTIVE 5
U_LMS 19-JAN-2003 jdbcuser jdbcclient INACTIVE 1
U_LMS 20-JAN-2003 jdbcuser jdbcclient INACTIVE 16
RPAD(USERNAME,1 TO_CHAR(LOG RPAD(OSUSER,20) RPAD(MODULE,15) RPAD(MACHINE,20) STATUS COUNT(*)
--------------- ----------- -------------------- --------------- -------------------- -------- ----------
U_LMS 21-JAN-2003 jdbcuser jdbcclient INACTIVE 4
U_LMS 22-JAN-2003 jdbcuser jdbcclient INACTIVE 4
U_HRIS 23-JAN-2003 Administrator SUNSIP.COM\WEBAC INACTIVE 1
U_LMS 23-JAN-2003 jdbcuser jdbcclient INACTIVE 2
U_LMS 24-JAN-2003 jdbcuser jdbcclient INACTIVE 7
U_LMS 26-JAN-2003 jdbcuser jdbcclient INACTIVE 1
U_LMS 27-JAN-2003 jdbcuser jdbcclient INACTIVE 4
U_LMS 28-JAN-2003 jdbcuser jdbcclient INACTIVE 3
U_LMS 29-JAN-2003 jdbcuser jdbcclient INACTIVE 3
U_LMS 30-JAN-2003 jdbcuser jdbcclient INACTIVE 4
U_LMS 31-JAN-2003 jdbcuser jdbcclient INACTIVE 1
44 rows selected.
BLAE: SYS>
Reply With Quote