[Home] [Help] [Dependency Information]
Object Name: | V_$AW_SESSION_INFO |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | |||
CLIENT_TYPE | VARCHAR2 | (64) | ||
SESSION_STATE | VARCHAR2 | (64) | ||
SESSION_HANDLE | NUMBER | |||
USERID | VARCHAR2 | (64) | ||
TOTAL_TRANSACTION | NUMBER | |||
TRANSACTION_TIME | NUMBER | |||
TOTAL_TRANSACTION_TIME | NUMBER | |||
AVERAGE_TRANSACTION_TIME | NUMBER | |||
TRANSACTION_CPU_TIME | NUMBER | |||
TOTAL_TRANSACTION_CPU_TIME | NUMBER | |||
AVERAGE_TRANSACTION_CPU_TIME | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, CLIENT_TYPE
, SESSION_STATE
, SESSION_HANDLE
, USERID
, TOTAL_TRANSACTION
, TRANSACTION_TIME
, TOTAL_TRANSACTION_TIME
, AVERAGE_TRANSACTION_TIME
, TRANSACTION_CPU_TIME
, TOTAL_TRANSACTION_CPU_TIME
, AVERAGE_TRANSACTION_CPU_TIME
, CON_ID
FROM SYS.V_$AW_SESSION_INFO;
|
|
|