RESUMABLE_TIMEOUT

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