C.2.3 DBA_HIST_ASM_DISKGROUP_STAT

The DBA_HIST_ASM_DISKGROUP_STAT view displays historic information about Oracle ASM disk groups.

Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

Unique snapshot identifier.

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

GROUP_NUMBER

NUMBER

NOT NULL

Cluster-wide number assigned to the disk group.

TOTAL_MB

NUMBER

Total capacity of the disk group in MB.

FREE_MB

NUMBER

Unused capacity in MB of the disk group.

NUM_DISK

NUMBER

Number of disks in the disk group.

NUM_FAILGROUP

NUMBER

Number of failure groups in the disk group.

STATE

VARCHAR2(32)

State of the disk group.

See also V$ASM_DISKGROUP.

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.