C.2.1 DBA_HIST_ASM_BAD_DISK

The DBA_HIST_ASM_BAD_DISK view displays historic information about non-online Oracle Automatic Storage Management (Oracle ASM) disks. This view contains snapshots of V$ASM_DISK.

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

Number of the disk group containing the disk.

NAME

VARCHAR2(128)

NOT NULL

Name of the disk.

PATH

VARCHAR2(256)

Operating system path name portion of the name returned by discovery.

STATUS

VARCHAR2(8)

NOT NULL

Global status for the disk. Only non-online disks are stored in this view.

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