| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | SNAPSHOT_ID | Oracle monitor: snapshot ID | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | * | ORA_SNAPSHOT_ID | Allow NULL? |
| 2 | INST_ID | Oracle monitor: Instance ID | decimal | 22 | 0 | DEC | ((0)) | No | | ORA_INST_ID | |
| 3 | WORKAREA_ADDRESS | Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle | varbinary | 8 | 0 | RAW | | No | | ORA_WORKAREA_ADDRESS | |
| 4 | ADDRESS | Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor | varbinary | 8 | 0 | RAW | | Yes | | ORA_ADDRESS | |
| 5 | HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_HASH_VALUE | |
| 6 | CHILD_NUMBER | Oracle Monitoring: CHILD_NUMBER | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_CHILD_NUMBER | |
| 7 | OPERATION_TYPE | Oracle Monitoring: OPERATION_TYPE | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ORA_OPERATION_TYPE | Allow NULL? |
| 8 | OPERATION_ID | Oracle Monitoring: OPERATION_ID | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_OPERATION_ID | |
| 9 | POLICY | Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | ORA_POLICY | Allow NULL? |
| 10 | ESTIMATED_OPTIMA | Oracle Monitoring: ESTIMATED_OPTIMAL_SIZE | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_ESTIMATED_OPTIMAL_SIZE | |
| 11 | ESTIMATED_ONEPAS | Oracle Monitoring: ESTIMATED_ONEPASS_SIZE | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_ESTIMATED_ONEPASS_SIZE | |
| 12 | LAST_MEMORY_USED | Oracle Monitoring: LAST_MEMORY_USED: Mem used for last exec | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_LAST_MEMORY_USED | |
| 13 | LAST_EXECUTION | Oracle Monitoring: LAST_EXECUTION | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ORA_LAST_EXECUTION | Allow NULL? |
| 14 | LAST_DEGREE | Oracle Monitoring: LAST_DEGREE: Deg of Parallelism of last | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_LAST_DEGREE | |
| 15 | TOTAL_EXECUTIONS | Oracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpass | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_TOTAL_EXECUTIONS | |
| 16 | OPTIMAL_EXECUTIO | Oracle Monitoring: OPTIMAL_EXECUTIONS | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_OPTIMAL_EXECUTIONS | |
| 17 | ONEPASS_EXECUTIO | Oracle Monitoring: ONEPASS_EXECUTIONS | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_ONEPASS_EXECUTIONS | |
| 18 | MULTIPASSES_EXEC | Oracle Monitoring: MULTIPASSES_EXECUTIONS | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_MULTIPASSES_EXECUTIONS | |
| 19 | ACTIVE_TIME | Oracle Monitoring: ACTIVE_TIME: Average Active Time | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_ACTIVE_TIME | |
| 20 | MAX_TEMPSEG_SIZE | Oracle Monitoring: MAX_TEMPSEG_SIZE | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_MAX_TEMPSEG_SIZE | |
| 21 | LAST_TEMPSEG_SIZ | Oracle Monitoring: LAST_TEMPSEG_SIZE | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_LAST_TEMPSEG_SIZE | |
