ASM Diskgroup Info

Create Or Replace Force View Sys.Av_asm_diskgroup (Group_number,
                                                   Name,
                                                   Sector_size,
                                                   Block_size,
                                                   Allocation_unit_size,
                                                   State,
                                                   Type,
                                                   Total_mb,
                                                   Free_mb,
                                                   Required_mirror_free_mb,
                                                   Usable_file_mb,
                                                   Offline_disks,
                                                   Unbalanced,
                                                   Compatibility,
                                                   Database_compatibility
                                                  )
As
   Select "GROUP_NUMBER", "NAME", "SECTOR_SIZE", "BLOCK_SIZE",
          "ALLOCATION_UNIT_SIZE", "STATE", "TYPE", "TOTAL_MB", "FREE_MB",
          "REQUIRED_MIRROR_FREE_MB", "USABLE_FILE_MB", "OFFLINE_DISKS",
          "UNBALANCED", "COMPATIBILITY", "DATABASE_COMPATIBILITY"
     From V$asm_diskgroup;