9.163 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.