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

5.299 DBA_ROLLING_STATISTICS

DBA_ROLLING_STATISTICS provides a list of rolling operation statistics.

Column Datatype NULL Description

NAME

VARCHAR2(256)

Name of the statistic. Possible values:

  • DBMS_ROLLING execution time
  • logical to primary switchover finish time
  • primary services offline for
  • primary to logical switchover start time
  • rolling upgrade finish time
  • rolling upgrade start time
  • time for former primary to fully recover upgrade redo
  • time for former primary to start upgrade redo recovery
  • total time former primary in physical role
  • transient logical creation finish time
  • transient logical creation start time
  • transient logical protection finish time
  • transient logical protection start time
  • user upgrade time

VALUE

VARCHAR2(256)

Value of the statistic

UPDATE_TIME

TIMESTAMP(6)

Time of last update

See Also:

Oracle Data Guard Concepts and Administration for more information about rolling operations.