2.224 MAX_SAGA_DURATION

MAX_SAGA_DURATION specifies the maximum duration for a saga (in seconds).

If a saga exists for longer than the amount of time specified by this parameter, it is considered incomplete and is eligible for termination.

Property Description

Parameter type

Integer

Default value

86400 seconds (equivalent to 24 hours)

Modifiable

ALTER SYSTEM

Modifiable in a PDB

No

Range of values

1 to 231 - 1

Basic

No

Oracle RAC

Multiple instances must have the same value.

Note:

This parameter is available starting with Oracle Database 23ai.