C.2.8 DBA_HIST_CELL_DISKTYPE

The DBA_HIST_CELL_DISKTYPE view displays historic information about cells, including the types of disks and the capacity of the disks. This view is derived from DBA_HIST_CELL_CONFIG and DBA_HIST_CELL_CONFIG_DETAIL.

Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

Unique snapshot identifier.

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

CELL_HASH

NUMBER

NOT NULL

Hash number to uniquely identify the cell.

CELL_NAME

VARCHAR2(4000)

User-readable cell name.

HARD_DISK_TYPE

VARCHAR2(4000)

The type of hard disk. The format of which is H/size, where size is suffixed by G, or T.

FLASH_DISK_TYPE

VARCHAR2(4000)

The type of flash, the format of which is F/size, where size is suffixed by G, or T.

NUM_CELL_DISKS

NUMBER

Number of cell disks.

NUM_GRID_DISKS

NUMBER

Number of grid disks.

NUM_HARD_DISKS

NUMBER

Number of hard disks.

NUM_FLASH_DISKS

NUMBER

Number of flash disks.

MAX_DISK_IOPS

NUMBER

The maximum number of IOPs for the hard disk type.

MAX_FLASH_IOPS

NUMBER

The maximum number of IOPs for the flash disk type.

MAX_DISK_MBPS

NUMBER

The maximum I/O throughput for the hard disk type, in megabytes per second.

MAX_FLASH_MBPS

NUMBER

The maximum I/O throughput for the flash disk type, in megabytes per second.

MAX_CELL_DISK_IOPS

NUMBER

The maximum number of hard disk IOPs for the cell. This is calculated using MAX_DISK_IOPS*NUM_HARD_DISKS.

MAX_CELL_FLASH_IOPS

NUMBER

The maximum number of flash IOPs for the cell. This is calculated using MAX_FLASH_IOPS*NUM_FLASH_DISKS.

MAX_CELL_DISK_MBPS

NUMBER

The maximum I/O throughput of hard disk for the cell., in megabytes per second. This is calculated using MAX_DISK_MBPS*NUM_HARD_DISKS.

MAX_CELL_FLASH_MBPS

NUMBER

The maximum I/O throughput flash for the cell, in megabytes per second. This is calculated using MAX_FLASH_MBPS*NUM_FLASH_DISKS.

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