Resumable Space Allocation 
Definition
This submonitor in the SAP/Oracle Database Monitor lets you check the resumable space allocation. If a statement is suspended for space allocation reasons, the resumable space allocation feature enables the statement to be resumed, so that the work done so far is saved.
Use
You choose Detailed Analyses ® Overall activity ® Resumable Space Allocation.
You can view history information in this submonitor.
Structure
Entries marked “RAC only” appear only for Oracle Real Application Cluster (RAC)
This screen displays the following information:
Column |
Description |
User ID |
User ID of the resumable statement owner |
Username |
User name of the resumable statement owner |
Session ID |
Session identifier |
Inst ID |
Instance ID of resumable statement |
Coord Inst_ID |
Inst ID on which the Parallel Coordinator is running |
Coord Sess ID |
Session ID of the Parallel Coordinator |
Status |
Statement status. Possible values: RUNNING, SUSPENDED, ABORTED, ABORTING, TIMEOUT |
Timeout |
Timeout of the resumable statement |
Start Time |
Local start time of the resumable statement |
Suspend Time |
Local last time when the resumable statement was suspended |
Resume Time |
Local last time when the resumable statement was resumed |
Name |
The name given in the resumable clause of this resumable statement. |
SQL Text |
SQL text of the resumable statement |
Error Number |
The error code of the last correctable error |
Error Parameter 1 |
Parameter for error message 1 |
Error Parameter 2 |
Parameter for error message 2 |
Error Parameter 3 |
Parameter for error message 3 |
Error Parameter 4 |
Parameter for error message 4 |
Error Parameter 5 |
Parameter for error message 5 |
Error Message |
The error message corresponding to Error Number. |