SELECT * FROM v$session; SADDR SID SERIAL# AUDSID PADDR USER# USERNAME COMMAND OWNERID TADDR LOCKWAIT STATUS SERVER SCHEMA# SCHEMANAME OSUSER PROCESS MACHINE TERMINAL PROGRAM TYPE SQL_ADDR SQL_HASH_V PREV_SQL PREV_HASH_ MODULE MODULE_HAS ACTION ACTION_HAS CLIENT_INFO FIXED_TABL ROW_WAIT_O ROW_WAIT_F ROW_WAIT_B ROW_WAIT_R LOGON_TIM LAST_CALL_ PDM FAILOVER_TYPE FAILOVER_M FAI RESOURCE_CONSUMER_GROUP PDML_STA PDDL_STA -------- ---------- ---------- ---------- -------- ---------- ------------------------------ ---------- ---------- -------- -------- -------- --------- ---------- ------------------------------ ------------------------------ --------- ---------------- ---------------- ---------------------------------------------------------------- ---------- -------- ---------- -------- ---------- ------------------------------------------------ ---------- -------------------------------- ---------- ---------------------------------------------------------------- ---------- ---------- ---------- ---------- ---------- --------- ---------- --- ------------- ---------- --- -------------------------------- -------- -------- 03C9F6F0 1 1 0 03C919B8 0 0 2147483644 ACTIVE DEDICATED 0 SYS Gavin JT Powell UNKNOWN JOE BLOGGS ORACLE.EXE BACKGROUND 00 0 00 0 0 0 0 -1 0 0 0 20-JUL-00 3181 NO NONE NONE NO DISABLED ENABLED 03C9FEB0 2 1 0 03C91CA8 0 0 2147483644 ACTIVE DEDICATED 0 SYS Gavin JT Powell UNKNOWN JOE BLOGGS ORACLE.EXE BACKGROUND 00 0 00 0 0 0 0 -1 0 0 0 20-JUL-00 3181 NO NONE NONE NO DISABLED ENABLED 03CA0670 3 1 0 03C91F98 0 0 2147483644 ACTIVE DEDICATED 0 SYS Gavin JT Powell UNKNOWN JOE BLOGGS ORACLE.EXE BACKGROUND 00 0 00 0 0 0 0 -1 0 0 0 20-JUL-00 3180 NO NONE NONE NO DISABLED ENABLED 03CA0E30 4 1 0 03C92288 0 0 2147483644 ACTIVE DEDICATED 0 SYS Gavin JT Powell UNKNOWN JOE BLOGGS ORACLE.EXE BACKGROUND 00 0 00 0 0 0 0 -1 0 0 0 20-JUL-00 3180 NO NONE NONE NO DISABLED ENABLED 03CA15F0 5 1 0 03C92578 0 0 2147483644 ACTIVE DEDICATED 0 SYS Gavin JT Powell UNKNOWN JOE BLOGGS ORACLE.EXE BACKGROUND 04B21DEC 1714733582 04B21DEC 1714733582 0 0 0 -1 0 0 0 20-JUL-00 3180 NO NONE NONE NO DISABLED ENABLED 03CA1DB0 6 1 0 03C92868 0 0 2147483644 ACTIVE DEDICATED 0 SYS Gavin JT Powell UNKNOWN JOE BLOGGS ORACLE.EXE BACKGROUND 04B435F0 3625995331 04B435F0 3625995331 0 0 0 -1 0 0 0 20-JUL-00 3179 NO NONE NONE NO DISABLED ENABLED 03CA34F0 9 68 60 03C92B58 5 SYSTEM 0 2147483644 ACTIVE DEDICATED 5 SYSTEM Gavin?JT?Powell 427856005 JOE BLOGGS JOE BLOGGS SVRMGRL.EXE USER 04A655CC 1426729873 04A655CC 1426729873 0 0 46 -1 0 0 0 20-JUL-00 0 NO NONE NONE NO SYS_GROUP DISABLED ENABLED