VIEW on ASM

V$ASM_DISKGROUP displays one row for every ASM disk group discovered by the ASM instance on the node.

select * from v$asm_diskgroup;

SQL> desc v$asm_disk;

 Name                                      Null?    Type

 ----------------------------------------- -------- ----------------------------

 GROUP_NUMBER                                       NUMBER

 DISK_NUMBER                                        NUMBER

 COMPOUND_INDEX                                     NUMBER

 INCARNATION                                        NUMBER

 MOUNT_STATUS                                       VARCHAR2(7)

 HEADER_STATUS                                      VARCHAR2(12)

 MODE_STATUS                                        VARCHAR2(7)

 STATE                                              VARCHAR2(8)

 REDUNDANCY                                         VARCHAR2(7)

 LIBRARY                                            VARCHAR2(64)

 OS_MB                                              NUMBER

 TOTAL_MB                                           NUMBER

 FREE_MB                                            NUMBER

 HOT_USED_MB                                        NUMBER

 COLD_USED_MB                                       NUMBER

 NAME                                               VARCHAR2(30)

 FAILGROUP                                          VARCHAR2(30)

 LABEL                                              VARCHAR2(31)

 PATH                                               VARCHAR2(256)

 UDID                                               VARCHAR2(64)

 PRODUCT                                            VARCHAR2(32)

 CREATE_DATE                                        DATE

 MOUNT_DATE                                         DATE

 REPAIR_TIMER                                       NUMBER

 READS                                              NUMBER

 WRITES                                             NUMBER

 READ_ERRS                                          NUMBER

 WRITE_ERRS                                         NUMBER

 READ_TIME                                          NUMBER

 WRITE_TIME                                         NUMBER

 BYTES_READ                                         NUMBER

 BYTES_WRITTEN                                      NUMBER

 PREFERRED_READ                                     VARCHAR2(1)

 HASH_VALUE                                         NUMBER

 HOT_READS                                          NUMBER

 HOT_WRITES                                         NUMBER

 HOT_BYTES_READ                                     NUMBER

 HOT_BYTES_WRITTEN                                  NUMBER

 COLD_READS                                         NUMBER

 COLD_WRITES                                        NUMBER

 COLD_BYTES_READ                                    NUMBER

 COLD_BYTES_WRITTEN                                 NUMBER

 VOTING_FILE                                        VARCHAR2(1)

 SECTOR_SIZE                                        NUMBER

 FAILGROUP_TYPE                                     VARCHAR2(7)

SQL>

select * from v$asm_disk;

select * from v$asm_operation;

select * from v$asm_diskgroup_stat;

select * from v$asm_client;

select * from v$asm_template;

select * from v$asm_file; 

select * from v$asm_alias;

select * from v$asm_attribute;