RESUMABLE_TIMEOUT

RESUMABLE_TIMEOUT enables or disables resumable statements and specifies resumable timeout at the system level.

Property Description
Parameter type Integer
Default value 0 (seconds)
Modifiable ALTER SESSION, ALTER SYSTEM
Modifiable in a PDB Yes
Range of values 0 to 231 - 1 (in seconds)
Basic No
Oracle RAC Multiple instances can have different values.

See Also: Oracle AI Database Administrator’s Guide for more information about enabling resumable space allocation, what conditions are correctable, and what statements can be made resumable