1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS
  4. DBA_HIST_SAGAS

6.45 DBA_HIST_SAGAS

DBA_HIST_SAGAS provides a history of all completed sagas in the database. Its columns are the same as those in ALL_HIST_SAGAS.

This view displays sagas that were either initiated in the current PDB or joined by participants in the current PDB.

Completed sagas are retained in this view for the length of time specified by the SAGA_HIST_RETENTION initialization parameter. The default is 30 days.

Note:

This view is available starting with Oracle Database 23ai.

See Also: