V$RAC_RECONFIGURATION_HISTOGRAM

V$RAC_RECONFIGURATION_HISTOGRAM displays histogram data on the elapsed time of Oracle RAC reconfiguration operations, grouped by reconfiguration type.

Column Datatype Description
TYPE VARCHAR2(29) Type of reconfiguration
TOTAL NUMBER Total number of completed reconfigurations for the reconfiguration type
BKT128MS NUMBER Number of completed reconfigurations with elapsed time less than 128 milliseconds
BKT256MS NUMBER Number of completed reconfigurations with elapsed time in the range [128, 256) milliseconds
BKT512MS NUMBER Number of completed reconfigurations with elapsed time in the range [256, 512) milliseconds
BKT1S NUMBER Number of completed reconfigurations with elapsed time in the range [512 milliseconds, 1 second)
BKT2S NUMBER Number of completed reconfigurations with elapsed time in the range [1, 2) seconds
BKT4S NUMBER Number of completed reconfigurations with elapsed time in the range [2, 4) seconds
BKT8S NUMBER Number of completed reconfigurations with elapsed time in the range [4, 8) seconds
BKT16S NUMBER Number of completed reconfigurations with elapsed time in the range [8, 16) seconds
BKTOVERFLOW NUMBER Number of completed reconfigurations with elapsed time of 16 seconds or more
CON_ID NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.26.3.