| 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 | BEGIN_TIME_D | Oracle monitoring: Begin of time interval (date field) | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ORA_BEGIN_TIME_D | Allow NULL? |
| 4 | BEGIN_TIME_T | Oracle monitoring: Begin of time interval (time field) | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | ORA_BEGIN_TIME_T | Allow NULL? |
| 5 | END_TIME_D | Oracle monitoring: End of time interval (date field) | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ORA_END_TIME_D | Allow NULL? |
| 6 | END_TIME_T | Oracle monitoring: End of time interval (time field) | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | ORA_END_TIME_T | Allow NULL? |
| 7 | UNDOTSN | Oracle monitoring: last active undo tablespace | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_UNDOTSN | |
| 8 | UNDOBLKS | Oracle monitoring: total number of undo blocks | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_UNDOBLKS | |
| 9 | TXNCOUNT | Oracle monitoring: total number of transactions | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_TXNCOUNT | |
| 10 | MAXQUERYLEN | Oracle monitoring: length of the longest query | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_MAXQUERYLEN | |
| 11 | MAXCONCURRENCY | Oracle monitoring: highest nr of TAs executed concurrently | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_MAXCONCURRENCY | |
| 12 | UNXPSTEALCNT | Oracle monitoring: attempts to obtain undo space | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_UNXPSTEALCNT | |
| 13 | UNXPBLKRELCNT | Oracle monitoring: unexpired undo blocks removed | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_UNXPBLKRELCNT | |
| 14 | UNXPBLKREUCNT | Oracle monitoring: unexpired undo blocks reused | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_UNXPBLKREUCNT | |
| 15 | EXPSTEALCNT | Oracle monitoring: attempts to steal expired undo blocks | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_EXPSTEALCNT | |
| 16 | EXPBLKRELCNT | Oracle monitoring: expired undo blocks stolen from segments | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_EXPBLKRELCNT | |
| 17 | EXPBLKREUCNT | Oracle monitoring: expired undo blocks reused | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_EXPBLKREUCNT | |
| 18 | SSOLDERRCNT | Oracle monitoring: number of times the error ORA-01555 occur | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_SSOLDERRCNT | |
| 19 | NOSPACEERRCNT | Oracle monitoring: number of times space was requested | decimal | 22 | 0 | DEC | ((0)) | Yes | | ORA_NOSPACEERRCNT | |