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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Unique snapshot identifier. |
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Hash number to uniquely identify the cell. |
|
VARCHAR2(4000) |
User-readable cell name. |
|
|
VARCHAR2(4000) |
The type of hard disk. The format of which is H/size, where size is suffixed by G, or T. |
|
|
VARCHAR2(4000) |
The type of flash, the format of which is F/size, where size is suffixed by G, or T. |
|
|
NUMBER |
Number of cell disks. |
|
|
NUMBER |
Number of grid disks. |
|
|
NUMBER |
Number of hard disks. |
|
|
NUMBER |
Number of flash disks. |
|
|
NUMBER |
The maximum number of IOPs for the hard disk type. |
|
|
NUMBER |
The maximum number of IOPs for the flash disk type. |
|
|
NUMBER |
The maximum I/O throughput for the hard disk type, in megabytes per second. |
|
|
NUMBER |
The maximum I/O throughput for the flash disk type, in megabytes per second. |
|
|
NUMBER |
The maximum number of hard disk IOPs for the cell. This is calculated using MAX_DISK_IOPS*NUM_HARD_DISKS. |
|
|
NUMBER |
The maximum number of flash IOPs for the cell. This is calculated using MAX_FLASH_IOPS*NUM_FLASH_DISKS. |
|
|
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. |
|
|
NUMBER |
The maximum I/O throughput flash for the cell, in megabytes per second. This is calculated using MAX_FLASH_MBPS*NUM_FLASH_DISKS. |
|
|
NUMBER |
The database identifier. |
|
|
NUMBER |
The identifier of the container identified by CON_DBID. Possible values are as follows:
|
Parent topic: Automatic Workload Repository Views