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 | 
|---|---|---|---|
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               NOT NULL  | 
                           
                               Unique snapshot identifier.  | 
                        
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               NOT NULL  | 
                           
                               Database identifier for the snapshot.  | 
                        
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               NOT NULL  | 
                           
                               Cluster-wide number assigned to the disk group.  | 
                        
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               Total capacity of the disk group in MB.  | 
                        |
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               Unused capacity in MB of the disk group.  | 
                        |
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               Number of disks in the disk group.  | 
                        |
| 
                              
                               
  | 
                           
                              
                               NUMBER  | 
                           
                              
                               Number of failure groups in the disk group.  | 
                        |
| 
                              
                               
  | 
                           
                              
                               VARCHAR2(32)  | 
                           
                              
                               State of the disk group. See also V$ASM_DISKGROUP.  | 
                        |
| 
                               
  | 
                           
                               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