| 11 |
10.2 |
10.1 |
sash |
|
|
|
|
|
| |
|
|
DBID |
|
| |
|
|
FIXED_TABLE_SEQUENCE |
|
| |
|
|
SQL_ADDRESS |
|
| |
|
|
SESSION_TYPE# |
|
| SAMPLE_ID |
SAMPLE_ID |
SAMPLE_ID |
SAMPLE_ID |
|
| SAMPLE_TIME |
SAMPLE_TIME |
SAMPLE_TIME |
SAMPLE_TIME |
|
| SESSION_ID |
SESSION_ID |
SESSION_ID |
SESSION_ID |
|
| SESSION_SERIAL# |
SESSION_SERIAL# |
SESSION_SERIAL# |
SESSION_SERIAL# |
|
| USER_ID |
USER_ID |
USER_ID |
USER_ID |
|
| SQL_ID |
SQL_ID |
SQL_ID |
SQL_ID |
|
| SQL_CHILD_NUMBER |
SQL_CHILD_NUMBER |
SQL_CHILD_NUMBER |
add |
|
| SQL_PLAN_HASH_VALUE |
SQL_PLAN_HASH_VALUE |
SQL_PLAN_HASH_VALUE |
add |
|
| FORCE_MATCHING_SIGNATURE |
FORCE_MATCHING_SIGNATURE |
|
add 9i+ ? |
Signature used when the CURSOR_SHARING parameter is set to FORCE |
| SQL_OPCODE |
SQL_OPCODE |
SQL_OPCODE |
SQL_OPCODE |
|
| PLSQL_ENTRY_OBJECT_ID |
PLSQL_ENTRY_OBJECT_ID |
|
|
|
| PLSQL_ENTRY_SUBPROGRAM_ID |
PLSQL_ENTRY_SUBPROGRAM_ID |
|
|
|
| PLSQL_OBJECT_ID |
PLSQL_OBJECT_ID |
|
|
|
| PLSQL_SUBPROGRAM_ID |
PLSQL_SUBPROGRAM_ID |
|
|
|
| SERVICE_HASH |
SERVICE_HASH |
SERVICE_HASH |
add 10g+ |
|
| SESSION_TYPE |
SESSION_TYPE |
SESSION_TYPE |
derive from session
type# |
|
| SESSION_STATE |
SESSION_STATE |
SESSION_STATE |
SESSION_STATE |
|
| QC_INSTANCE_ID |
QC_SESSION_ID |
QC_SESSION_ID |
add |
|
| QC_SESSION_ID |
QC_INSTANCE_ID |
QC_INSTANCE_ID |
add |
|
| QC_SESSION_SERIAL# |
|
|
add |
|
| BLOCKING_SESSION_STATUS |
BLOCKING_SESSION |
|
|
|
| BLOCKING_SESSION |
BLOCKING_SESSION_STATUS |
|
|
|
| BLOCKING_SESSION_SERIAL# |
BLOCKING_SESSION_SERIAL# |
|
|
|
| EVENT |
EVENT |
EVENT |
join in v$event_name |
|
| EVENT_ID |
EVENT_ID |
EVENT_ID |
not useful or needed |
|
| EVENT# |
EVENT# |
EVENT# |
EVENT# |
|
| SEQ# |
SEQ# |
SEQ# |
SEQ# |
|
| P1TEXT |
P1TEXT |
|
join in v$event_name |
|
| P1 |
P1 |
P1 |
P1 |
|
| P2TEXT |
P2TEXT |
|
join in v$event_name |
|
| P2 |
P2 |
P2 |
P2 |
|
| P3TEXT |
P3TEXT |
|
join in v$event_name |
|
| P3 |
P3 |
P3 |
P3 |
|
| WAIT_CLASS |
WAIT_CLASS |
|
add |
|
| WAIT_CLASS_ID |
WAIT_CLASS_ID |
|
add |
|
| WAIT_TIME |
WAIT_TIME |
WAIT_TIME |
WAIT_TIME |
|
| TIME_WAITED |
TIME_WAITED |
TIME_WAITED |
not useful |
|
| XID |
XID |
|
add |
|
| CURRENT_OBJ# |
CURRENT_OBJ# |
CURRENT_OBJ# |
CURRENT_OBJ# |
|
| CURRENT_FILE# |
CURRENT_FILE# |
CURRENT_FILE# |
CURRENT_FILE# |
|
| CURRENT_BLOCK# |
CURRENT_BLOCK# |
CURRENT_BLOCK# |
CURRENT_BLOCK# |
|
| CURRENT_ROW# |
|
|
add |
|
| PROGRAM |
PROGRAM |
PROGRAM |
PROGRAM |
|
| MODULE |
MODULE |
MODULE |
MODULE |
|
| ACTION |
ACTION |
ACTION |
ACTION |
|
| CLIENT_ID |
CLIENT_ID |
CLIENT_ID |
add for 10g+ |
|
| REMOTE_INSTANCE# |
|
|
|
|
| |
|
|
|
|
| CONSUMER_GROUP_ID |
|
|
|
|
| |
|
|
|
|
| IN_CONNECTION_MGMT |
|
|
|
|
| IN_PARSE |
|
|
|
|
| IN_HARD_PARSE |
|
|
|
|
| IN_SQL_EXECUTION |
|
|
|
|
| IN_PLSQL_EXECUTION |
|
|
|
|
| IN_PLSQL_RPC |
|
|
|
|
| IN_PLSQL_COMPILATION |
|
|
|
|
| IN_JAVA_EXECUTION |
|
|
|
|
| IN_BIND |
|
|
|
|
| IN_CURSOR_CLOSE |
|
|
|
|
| |
|
|
|
|
| TOP_LEVEL_SQL_ID |
|
|
|
|
| TOP_LEVEL_SQL_OPCODE |
|
|
|
|
| SQL_PLAN_LINE_ID |
|
|
|
|
| SQL_PLAN_OPERATION |
|
|
|
|
| SQL_PLAN_OPTIONS |
|
|
|
|
| SQL_EXEC_ID |
|
|
|
|
| SQL_EXEC_START |
|
|
|
|
| |
|
|
|
|
| FLAGS |
|
|
|
Reserved for future use |
|
|
|
|
|
|
|
|
|
|