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 AI Database 26ai.
See Also: