SNAPSHOT_ID |
✔ |
Oracle monitor: snapshot ID |
ORA_SNAPSHOT_ID |
NUMC |
10 |
* |
INST_ID |
✔ |
Oracle monitor: Instance ID |
ORA_INST_ID |
DEC |
22 |
|
WORKAREA_ADDRESS |
✔ |
Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle |
ORA_WORKAREA_ADDRESS |
RAW |
8 |
|
ADDRESS |
|
Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor |
ORA_ADDRESS |
RAW |
8 |
|
HASH_VALUE |
|
Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment |
ORA_HASH_VALUE |
DEC |
22 |
|
CHILD_NUMBER |
|
Oracle Monitoring: CHILD_NUMBER |
ORA_CHILD_NUMBER |
DEC |
22 |
|
OPERATION_TYPE |
|
Oracle Monitoring: OPERATION_TYPE |
ORA_OPERATION_TYPE |
CHAR |
20 |
|
OPERATION_ID |
|
Oracle Monitoring: OPERATION_ID |
ORA_OPERATION_ID |
DEC |
22 |
|
POLICY |
|
Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto) |
ORA_POLICY |
CHAR |
6 |
|
ESTIMATED_OPTIMA |
|
Oracle Monitoring: ESTIMATED_OPTIMAL_SIZE |
ORA_ESTIMATED_OPTIMAL_SIZE |
DEC |
22 |
|
ESTIMATED_ONEPAS |
|
Oracle Monitoring: ESTIMATED_ONEPASS_SIZE |
ORA_ESTIMATED_ONEPASS_SIZE |
DEC |
22 |
|
LAST_MEMORY_USED |
|
Oracle Monitoring: LAST_MEMORY_USED: Mem used for last exec |
ORA_LAST_MEMORY_USED |
DEC |
22 |
|
LAST_EXECUTION |
|
Oracle Monitoring: LAST_EXECUTION |
ORA_LAST_EXECUTION |
CHAR |
10 |
|
LAST_DEGREE |
|
Oracle Monitoring: LAST_DEGREE: Deg of Parallelism of last |
ORA_LAST_DEGREE |
DEC |
22 |
|
TOTAL_EXECUTIONS |
|
Oracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpass |
ORA_TOTAL_EXECUTIONS |
DEC |
22 |
|
OPTIMAL_EXECUTIO |
|
Oracle Monitoring: OPTIMAL_EXECUTIONS |
ORA_OPTIMAL_EXECUTIONS |
DEC |
22 |
|
ONEPASS_EXECUTIO |
|
Oracle Monitoring: ONEPASS_EXECUTIONS |
ORA_ONEPASS_EXECUTIONS |
DEC |
22 |
|
MULTIPASSES_EXEC |
|
Oracle Monitoring: MULTIPASSES_EXECUTIONS |
ORA_MULTIPASSES_EXECUTIONS |
DEC |
22 |
|
ACTIVE_TIME |
|
Oracle Monitoring: ACTIVE_TIME: Average Active Time |
ORA_ACTIVE_TIME |
DEC |
22 |
|
MAX_TEMPSEG_SIZE |
|
Oracle Monitoring: MAX_TEMPSEG_SIZE |
ORA_MAX_TEMPSEG_SIZE |
DEC |
22 |
|
LAST_TEMPSEG_SIZ |
|
Oracle Monitoring: LAST_TEMPSEG_SIZE |
ORA_LAST_TEMPSEG_SIZE |
DEC |
22 |
|