ORA_RESUMABLE - Oracle monitor: Copy of DBA_RESUMABLE
Oracle monitor: Copy of DBA_RESUMABLE information is stored in SAP table ORA_RESUMABLE.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table ORA_RESUMABLE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| USER_ID | Oracle monitor: User id | X | ORA_USER_ID | DEC | 12 | |
| SESSION_ID | Oracle monitor: Session id | X | ORA_SESSION_ID_I | DEC | 12 | |
| INSTANCE_ID | Oracle monitor: Instance ID | X | ORA_INST_ID | DEC | 12 | |
| COORD_INST_ID | Oracle monitor: Coord instance id | ORA_COORD_INSTANCE_ID | DEC | 12 | ||
| COORD_SESSION_ID | Oracle monitor: Coord session id | ORA_COORD_SESSION_ID | DEC | 12 | ||
| STATUS | Oracle monitoring: Current process status | ORA_STATUS | CHAR | 12 | ||
| TIMEOUT | Oracle monitor: Timeout | ORA_TIMEOUT | DEC | 12 | ||
| START_TIME | Oracle monitoring:START_TIME:Start time of the operation | ORA_START_TIME | CHAR | 20 | ||
| SUSPEND_TIME | Oracle monitor: Suspend time | ORA_SUSPEND_TIME | CHAR | 20 | ||
| RESUME_TIME | Oracle monitor: Resume time | ORA_RESUME_TIME | CHAR | 20 | ||
| NAME | Oracle monitor: Name | ORA_NAME_1 | CHAR | 255 | ||
| ERROR_NUMBER | Oracle monitor: Error number | ORA_ERROR_NUMBER | DEC | 12 | ||
| ERROR_PARAMETER1 | Oracle monitor: Error parameter | ORA_ERROR_PARAMETER | CHAR | 80 | ||
| ERROR_PARAMETER2 | Oracle monitor: Error parameter | ORA_ERROR_PARAMETER | CHAR | 80 | ||
| ERROR_PARAMETER3 | Oracle monitor: Error parameter | ORA_ERROR_PARAMETER | CHAR | 80 | ||
| ERROR_PARAMETER4 | Oracle monitor: Error parameter | ORA_ERROR_PARAMETER | CHAR | 80 | ||
| ERROR_PARAMETER5 | Oracle monitor: Error parameter | ORA_ERROR_PARAMETER | CHAR | 80 | ||
| ERROR_MSG | Oracle monitor: Error msg | ORA_ERROR_MSG | CHAR | 255 | ||
| SQL_TEXT_LENGTH | Oracle Monitoring: Field to store length of long char types | ORA_TEXT_LENGTH | INT4 | 4 | ||
| SQL_TEXT | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | ORA_SQL_TEXT | LCHR | 1000 |