| Property | Description |
|---|---|
| Parameter type | Integer |
| Default value | 0 (seconds) |
| Modifiable | ALTER SESSION, ALTER SYSTEM |
| Range of values | 0 to 231 - 1 (in seconds) |
| Oracle RAC | Multiple instances can have different values. |
RESUMABLE_TIMEOUT enables or disables resumable statements and specifies resumable timeout at the system level.
See Also:
Oracle Database Administrator's Guide for more information about enabling resumable space allocation, what conditions are correctable, and what statements can be made resumable