1.306 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 Database Administrator’s Guide for more information about enabling resumable space allocation, what conditions are correctable, and what statements can be made resumable