MAX_SAGA_DURATION

2.225 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 2³¹ - 1
Basic	No
Oracle RAC	Multiple instances must have the same value.

Note:

This parameter is available starting with Oracle Database 23ai.