C.2.6 DBA_HIST_CELL_CONFIG_DETAIL

The DBA_HIST_CELL_CONFIG_DETAIL view displays historic information about the configuration of the cells. This view has the same descriptions as DBA_HIST_CELL_CONFIG, but includes the data for each snapshot, such as a historic view.

Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

Unique snapshot identifier.

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

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

Parent topic: Automatic Workload Repository Views