C.2.5 DBA_HIST_CELL_CONFIG

The DBA_HIST_CELL_CONFIG view contains information about the configuration of the cells. This data is from V$CELL_CONFIG_INFO.

Column Datatype NULL Description

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

CURRENT_SNAP_ID

NUMBER

NOT NULL

AWR snapshot identifier for when the configuration was captured.

CELLNAME

VARCHAR2(256)

NOT NULL

Unique identifier for the cell.

CELLHASH

NUMBER

NOT NULL

Hash number to uniquely identify the cell.

CONFTYPE

VARCHAR2(15)

NOT NULL

Configuration type. The configuration type determines the type of information stored in the CONFVAL column.

  • AWRXML: configuration information pertinent to AWR reports.

  • CELL: configuration information about the cell.

  • CELLDISK: configuration information about cell disks.

  • GRIDDISK: configuration information about grid disks.

  • IORM_OBJ: IORM objective.

  • OFFLOAD: configuration information for offload servers.

  • PHYSICALDISK: configuration information about physical disks.

CONFVAL

CLOB

XML data associated with CONFTYPE.

CON_DBID

NUMBER

The database identifier.

CON_ID

NUMBER

The identifier of the container identified by CON_DBID. Possible values are as follows:

  • 0: This value is used for non-container database (CDB).

  • 1: This value is used for the root container of the CDB.