SNAP_ID |
NUMBER |
|
Unique snapshot ID |
DBID |
NUMBER |
|
Database ID for the snapshot |
INSTANCE_NUMBER |
NUMBER |
|
Instance number for the snapshot |
SAMPLE_ID |
NUMBER |
|
ID of the sample |
SAMPLE_TIME |
TIMESTAMP(3) |
|
Time of the sample |
SESSION_ID |
NUMBER |
|
Session identifier |
SESSION_SERIAL# |
NUMBER |
|
Session serial number (used to uniquely identify a session's objects) |
USER_ID |
NUMBER |
|
Oracle user identifier |
SQL_ID |
VARCHAR2(13) |
|
SQL identifier of the SQL statement that is currently being executed |
SQL_CHILD_NUMBER |
NUMBER |
|
Child number of the SQL statement that is currently being executed |
SQL_PLAN_HASH_VALUE |
NUMBER |
|
Numerical representation of the SQL plan for the cursor |
SERVICE_HASH |
NUMBER |
|
Hash that identifies the Service |
SESSION_TYPE |
NUMBER |
|
Session type |
SQL_OPCODE |
NUMBER |
|
Indicates what phase of operation the SQL statement is in |
QC_SESSION_ID |
NUMBER |
|
Query coordinator session ID |
QC_INSTANCE_ID |
NUMBER |
|
Query coordinator instance ID |
CURRENT_OBJ# |
NUMBER |
|
Object ID of the object that the session is currently referencing |
CURRENT_FILE# |
NUMBER |
|
File number of the file containing the block that the session is currently referencing |
CURRENT_BLOCK# |
NUMBER |
|
ID of the block that the session is currently referencing |
SEQ# |
NUMBER |
|
Sequence number that uniquely identifies the wait (incremented for each wait) |
EVENT_ID |
NUMBER |
|
Identifier of the resource or event for which the session is waiting or for which the session last waited |
P1 |
NUMBER |
|
First additional parameter |
P2 |
NUMBER |
|
Second additional parameter |
P3 |
NUMBER |
|
Third additional parameter |
WAIT_TIME |
NUMBER |
|
Total wait time for the event for which the session last waited (0 if currently waiting) |
TIME_WAITED |
NUMBER |
|
Time that the current session actually spent waiting for the event. This column is set for waits that were in progress at the time the sample was taken. |
PROGRAM |
VARCHAR2(48) |
|
Name of the operating system program |
MODULE |
VARCHAR2(48) |
|
Name of the currently executing module as set by the DBMS_APPLICATION_INFO.SET_MODULE procedure |
ACTION |
VARCHAR2(32) |
|
Name of the currently executing action as set by the DBMS_APPLICATION_INFO.SET_ACTION procedure |
CLIENT_ID |
VARCHAR2(64) |
|
Client identifier of the session |
