| Property | Description | 
|---|---|
| Parameter type | Integer | 
| Default value | 0(seconds) | 
| Modifiable | ALTER SESSION,ALTER SYSTEM | 
| Range of values | 0to 231 - 1 (in seconds) | 
| Real Application Clusters | 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