2.350 SAGA_HIST_RETENTION

SAGA_HIST_RETENTION specifies the length of time (in minutes) that completed sagas are retained in the DBA_HIST_SAGAS and USER_HIST_SAGAS views.

Property	Description
Parameter type	Integer
Default value	43200 minutes (equivalent to 30 days)
Modifiable	ALTER SYSTEM
Modifiable in a PDB	No
Range of values	1 - 2147483647 minutes
Basic	No
Oracle RAC	Multiple instances must have the same value.

Note:

This parameter is available starting with Oracle Database 23ai.

See Also:

• "ALL_HIST_SAGAS"

• "DBA_HIST_SAGAS"

• "USER_HIST_SAGAS"