Storage Administration - Oracle Exadata Recipes: A Problem-Solution Approach - page 255

Next, execute the following query to show how many grid disks are used per storage cell per ASM disk group:
SQL> select a.name,b.failgroup,count(*) cnt
from v$asm_diskgroup a, v$asm_disk b
where a.group_number=b.group_number
group by a.name,b.failgroup
/
Disk Group Cell Disks per Cell
------------ ---------- --------------
DBFS_DG CM01CEL01 10
DBFS_DG CM01CEL02 10
DBFS_DG CM01CEL03 10
DATA_CM01 CM01CEL01 12
DATA_CM01 CM01CEL02 12
DATA_CM01 CM01CEL03 12
RECO_CM01 CM01CEL01 12
RECO_CM01 CM01CEL02 12
RECO_CM01 CM01CEL03 12
SDATA_CM01 CM01CEL01 12
SDATA_CM01 CM01CEL02 12
SDATA_CM01 CM01CEL03 12
SRECO_CM01 CM01CEL01 12
SRECO_CM01 CM01CEL02 12
SRECO_CM01 CM01CEL03 12
15 rows selected.
Finally, list your ASM disk group attributes. These will be required to recreate our ASM disk groups:
SQL> select a.group_number,b.name dgname,a.name,a.value
from v$asm_attribute a,
v$asm_diskgroup b
where a.name in ('au_size','disk_repair_time',
'compatible.rdbms','compatible.asm')
and a.group_number=b.group_number
order by b.name,a.name
/
Group DiskGroup ASM Attribute ASM Attribute
Number Name Name Value
------- ------------ ----------------- ----------------
1 DATA_CM01 au_size 4194304
1 DATA_CM01 compatible.asm 11.2.0.3.0
1 DATA_CM01 compatible.rdbms 11.2.0.3.0
1 DATA_CM01 disk_repair_time 3.6h
... Other disk groups omitted for brevity
20 rows selected.
SQL>