Table: DBA_RESUMABLE
Resumable session information in the system
| Column Name | Description |
|---|---|
| COORD_INSTANCE_ID | Instance number of parallel query coordinator |
| COORD_SESSION_ID | Session number of parallel query coordinator |
| ERROR_MSG | The current error message |
| ERROR_NUMBER | The current error number |
| ERROR_PARAMETER1 | The 1st parameter to the current error message |
| ERROR_PARAMETER2 | The 2nd parameter to the current error message |
| ERROR_PARAMETER3 | The 3rd parameter to the current error message |
| ERROR_PARAMETER4 | The 4th parameter to the current error message |
| ERROR_PARAMETER5 | The 5th parameter to the current error message |
| INSTANCE_ID | Instance ID of this resumable session |
| NAME | Name of this resumable session |
| RESUME_TIME | Resume time of the current statement |
| SESSION_ID | Session ID of this resumable session |
| SQL_TEXT | The current SQL text |
| START_TIME | Start time of the current transaction |
| STATUS | Status of this resumable session |
| SUSPEND_TIME | Suspend time of the current statement |
| TIMEOUT | Timeout of this resumable session |
| USER_ID | User who own this resumable session |