C.2.2 DBA_HIST_ASM_DISKGROUP

The DBA_HIST_ASM_DISKGROUP view contains information about Oracle ASM disk groups. This retrieves a subset of columns from V$ASM_DISKGROUP.

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 disk group was captured.

GROUP_NUMBER

NUMBER

NOT NULL

Cluster-wide number assigned to the disk group.

NAME

VARCHAR2(128)

NOT NULL

Name of the disk group.

TYPE

VARCHAR2(6)

Redundancy type for the disk group.

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