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_ADDRESS
|
SQL_HASH_VALUE
|
PREV_SQL_ADDR
|
PREV_HASH_VALUE
|
MODULE
|
MODULE_HASH
|
ACTION
|
ACTION_HASH
|
CLIENT_INFO
|
FIXED_TABLE_SEQUENCE
|
ROW_WAIT_OBJ#
|
ROW_WAIT_FILE#
|
ROW_WAIT_BLOCK#
|
ROW_WAIT_ROW#
|
LOGON_TIME
|
LAST_CALL_ET
|
PDML_ENABLED
|
FAILOVER_TYPE
|
FAILOVER_METHOD
|
FAILED_OVER
|
RESOURCE_CONSUMER_GROUP
|
PDML_STATUS
|
PDDL_STATUS
|
PQ_STATUS
|
CURRENT_QUEUE_DURATION
|
CLIENT_IDENTIFIER
|
|
1F3040D4
|
1
|
1
|
0
|
1F2D13DC
|
0
|
null
|
0
|
2147483644
|
null
|
null
|
ACTIVE
|
DEDICATED
|
0
|
SYS
|
SYSTEM
|
1712
|
LARRYSERVER
|
LARRYSERVER
|
ORACLE.EXE
|
BACKGROUND
|
00
|
0
|
00
|
0
|
null
|
0
|
null
|
0
|
null
|
0
|
-1
|
0
|
0
|
0
|
2006-10-24 20:33:44.0
|
4678
|
NO
|
NONE
|
NONE
|
NO
|
null
|
DISABLED
|
ENABLED
|
ENABLED
|
0
|
null
|
|
1F304A44
|
2
|
1
|
0
|
1F2D179C
|
0
|
null
|
0
|
2147483644
|
null
|
null
|
ACTIVE
|
DEDICATED
|
0
|
SYS
|
SYSTEM
|
2624
|
LARRYSERVER
|
LARRYSERVER
|
ORACLE.EXE
|
BACKGROUND
|
00
|
0
|
00
|
0
|
null
|
0
|
null
|
0
|
null
|
0
|
-1
|
0
|
0
|
0
|
2006-10-24 20:33:44.0
|
4678
|
NO
|
NONE
|
NONE
|
NO
|
null
|
DISABLED
|
ENABLED
|
ENABLED
|
0
|
null
|
|
1F3053B4
|
3
|
1
|
0
|
1F2D1B5C
|
0
|
null
|
0
|
2147483644
|
null
|
null
|
ACTIVE
|
DEDICATED
|
0
|
SYS
|
SYSTEM
|
624
|
LARRYSERVER
|
LARRYSERVER
|
ORACLE.EXE
|
BACKGROUND
|
00
|
0
|
00
|
0
|
null
|
0
|
null
|
0
|
null
|
0
|
-1
|
0
|
0
|
0
|
2006-10-24 20:33:45.0
|
4678
|
NO
|
NONE
|
NONE
|
NO
|
null
|
DISABLED
|
ENABLED
|
ENABLED
|
0
|
null
|
|
1F305D24
|
4
|
1
|
0
|
1F2D1F1C
|
0
|
null
|
0
|
2147483644
|
null
|
null
|
ACTIVE
|
DEDICATED
|
0
|
SYS
|
SYSTEM
|
2208
|
LARRYSERVER
|
LARRYSERVER
|
ORACLE.EXE
|
BACKGROUND
|
00
|
0
|
00
|
0
|
null
|
0
|
null
|
0
|
null
|
0
|
-1
|
0
|
0
|
0
|
2006-10-24 20:33:45.0
|
4678
|
NO
|
NONE
|
NONE
|
NO
|
null
|
DISABLED
|
ENABLED
|
ENABLED
|
0
|
null
|
|
1F306694
|
5
|
1
|
0
|
1F2D22DC
|
0
|
null
|
0
|
2147483644
|
null
|
null
|
ACTIVE
|
DEDICATED
|
0
|
SYS
|
SYSTEM
|
3964
|
LARRYSERVER
|
LARRYSERVER
|
ORACLE.EXE
|
BACKGROUND
|
20D475FC
|
260339297
|
20D4BDC4
|
3665763022
|
null
|
0
|
null
|
0
|
null
|
0
|
0
|
2
|
0
|
0
|
2006-10-24 20:33:45.0
|
4678
|
NO
|
NONE
|
NONE
|
NO
|
null
|
DISABLED
|
ENABLED
|
ENABLED
|
0
|
null
|
|
1F307004
|
6
|
1
|
0
|
1F2D269C
|
0
|
null
|
0
|
2147483644
|
null
|
null
|
ACTIVE
|
DEDICATED
|
0
|
SYS
|
SYSTEM
|
4016
|
LARRYSERVER
|
LARRYSERVER
|
ORACLE.EXE
|
BACKGROUND
|
20D59D44
|
2618850598
|
20D59D44
|
2618850598
|
null
|
0
|
null
|
0
|
null
|
0
|
-1
|
0
|
0
|
0
|
2006-10-24 20:33:46.0
|
4678
|
NO
|
NONE
|
NONE
|
NO
|
null
|
DISABLED
|
ENABLED
|
ENABLED
|
0
|
null
|
|
1F307974
|
7
|
1
|
0
|
1F2D2A5C
|
0
|
null
|
0
|
2147483644
|
null
|
null
|
ACTIVE
|
DEDICATED
|
0
|
SYS
|
SYSTEM
|
2396
|
LARRYSERVER
|
LARRYSERVER
|
ORACLE.EXE
|
USER
|
00
|
0
|
20E8A7F0
|
1693927332
|
null
|
0
|
null
|
0
|
null
|
0
|
-1
|
0
|
0
|
0
|
2006-10-24 20:33:46.0
|
4678
|
NO
|
NONE
|
NONE
|
NO
|
null
|
DISABLED
|
ENABLED
|
ENABLED
|
0
|
null
|
|
1F3082E4
|
8
|
1
|
0
|
1F2D2E1C
|
0
|
null
|
0
|
2147483644
|
null
|
null
|
ACTIVE
|
DEDICATED
|
0
|
SYS
|
SYSTEM
|
2460
|
LARRYSERVER
|
LARRYSERVER
|
ORACLE.EXE
|
USER
|
20D6288C
|
870116171
|
20D72138
|
1153132087
|
null
|
0
|
null
|
0
|
null
|
0
|
-1
|
1
|
0
|
0
|
2006-10-24 20:33:46.0
|
4678
|
NO
|
NONE
|
NONE
|
NO
|
null
|
DISABLED
|
ENABLED
|
ENABLED
|
0
|
null
|
|
1F308C54
|
9
|
176
|
1271
|
1F2D31DC
|
23
|
WCUSER
|
0
|
2147483644
|
null
|
null
|
INACTIVE
|
DEDICATED
|
23
|
WCUSER
|
Lawrence L Jett Jr
|
null
|
LarrySERVER
|
unknown
|
JDBC Thin Client
|
USER
|
214776D4
|
526472908
|
214776D4
|
526472908
|
JDBC Thin Client
|
0
|
null
|
0
|
null
|
639
|
6422
|
6
|
0
|
0
|
2006-10-24 21:43:15.0
|
60
|
NO
|
NONE
|
NONE
|
NO
|
DEFAULT_CONSUMER_GROUP
|
DISABLED
|
ENABLED
|
ENABLED
|
0
|
null
|
|
1F3095C4
|
10
|
71
|
1272
|
1F2D359C
|
23
|
WCUSER
|
0
|
2147483644
|
null
|
null
|
INACTIVE
|
DEDICATED
|
23
|
WCUSER
|
Lawrence L Jett Jr
|
null
|
LarrySERVER
|
unknown
|
JDBC Thin Client
|
USER
|
212127F0
|
1642867126
|
212127F0
|
1642867126
|
JDBC Thin Client
|
0
|
null
|
0
|
null
|
639
|
6616
|
4
|
0
|
0
|
2006-10-24 21:43:17.0
|
60
|
NO
|
NONE
|
NONE
|
NO
|
DEFAULT_CONSUMER_GROUP
|
DISABLED
|
ENABLED
|
ENABLED
|
0
|
null
|
|
1F30A8A4
|
12
|
36
|
1273
|
1F2D395C
|
23
|
WCUSER
|
0
|
2147483644
|
null
|
null
|
INACTIVE
|
DEDICATED
|
23
|
WCUSER
|
Lawrence L Jett Jr
|
null
|
LarrySERVER
|
unknown
|
JDBC Thin Client
|
USER
|
2110853C
|
4031250256
|
2110853C
|
4031250256
|
JDBC Thin Client
|
0
|
null
|
0
|
null
|
646
|
-1
|
0
|
0
|
0
|
2006-10-24 21:43:18.0
|
0
|
NO
|
NONE
|
NONE
|
NO
|
DEFAULT_CONSUMER_GROUP
|
DISABLED
|
ENABLED
|
ENABLED
|
0
|
null
|
|
1F30B214
|
13
|
36
|
1274
|
1F2D3D1C
|
23
|
WCUSER
|
0
|
2147483644
|
null
|
null
|
INACTIVE
|
DEDICATED
|
23
|
WCUSER
|
Lawrence L Jett Jr
|
null
|
LarrySERVER
|
unknown
|
JDBC Thin Client
|
USER
|
2110853C
|
4031250256
|
2110853C
|
4031250256
|
JDBC Thin Client
|
0
|
null
|
0
|
null
|
639
|
7005
|
6
|
0
|
0
|
2006-10-24 21:43:18.0
|
60
|
NO
|
NONE
|
NONE
|
NO
|
DEFAULT_CONSUMER_GROUP
|
DISABLED
|
ENABLED
|
ENABLED
|
0
|
null
|
|
1F30BB84
|
14
|
36
|
1275
|
1F2D40DC
|
23
|
WCUSER
|
0
|
2147483644
|
null
|
null
|
INACTIVE
|
DEDICATED
|
23
|
WCUSER
|
Lawrence L Jett Jr
|
null
|
LarrySERVER
|
unknown
|
JDBC Thin Client
|
USER
|
2099DC2C
|
1102437051
|
2099DC2C
|
1102437051
|
JDBC Thin Client
|
0
|
null
|
0
|
null
|
639
|
-1
|
0
|
0
|
0
|
2006-10-24 21:43:18.0
|
60
|
NO
|
NONE
|
NONE
|
NO
|
DEFAULT_CONSUMER_GROUP
|
DISABLED
|
ENABLED
|
ENABLED
|
0
|
null
|
|
1F30F424
|
20
|
106
|
1293
|
1F2D449C
|
5
|
SYSTEM
|
0
|
2147483644
|
null
|
null
|
ACTIVE
|
DEDICATED
|
5
|
SYSTEM
|
Lawrence L Jett Jr
|
null
|
LarrySERVER
|
unknown
|
JDBC Thin Client
|
USER
|
20941868
|
983725192
|
20941868
|
983725192
|
JDBC Thin Client
|
0
|
null
|
0
|
null
|
649
|
-1
|
0
|
0
|
0
|
2006-10-24 21:51:44.0
|
0
|
NO
|
NONE
|
NONE
|
NO
|
SYS_GROUP
|
DISABLED
|
ENABLED
|
ENABLED
|
0
|
null
|