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

cm01cel02: 284G
cm01cel02: 29.125G
cm01cel02: 36.6875G
cm01cel02: 67G
cm01cel03: 141G
cm01cel03: 284G
cm01cel03: 29.125G
cm01cel03: 36.6875G
cm01cel03: 67G
[oracle@cm01dbm01 ~]$

From this output, we see a repeating pattern of grid disk sizes across all cell disks and all storage servers.

■ Note this is often the expected configuration when grid disk management best practices are followed.

If you total the size for each grid disk, you arrive at a total size of 557.8395 GB. Now, validate the size of each cell
disk to determine whether you have capacity to add grid disks:

[oracle@cm01dbm01 ~]$ dcli -g ./cell_group cellcli -e list celldisk where disktype=hardDisk
attributes name,size \
> | awk '{print $3}'|sort -u
528.734375G
557.859375G
[oracle@cm01dbm01 ~]$

As expected, in this output, we have two different cell disk sizes—one of the two cell disks that reside on physical
disks where the System Area resides and ten with the larger size. Based on this and our grid disk sizes, we can see that
in this case we do not have physical capacity to add additional Exadata grid disks. To ensure that you're actually using
all the grid disks on your system, log in to one of your ASM instances and run the query in Listing 9-1.

Listing 9-1. lst09-01-asm-disk-details.sql
SQL> col name format a12 head 'Disk Group'
SQL> col total_mb format 999999999 head 'Total MB|Raw'
SQL> col free_mb format 999999999 head 'Free MB|Raw'
SQL> col avail_mb format 999999999 head 'Total MB|Usable'
SQL> col usable_mb format 999999999 head 'Free MB|Usable'
SQL> col cdisks format 99999 head 'Cell|Disksl
SQL> select a.name,a.total_mb,a.free_mb,a.type,
decode(a.type,'NORMAL',a.total_mb/2,'HIGH',a.total_mb/3) avail_mb,
decode(a.type,'NORMAL',a.free_mb/2,'HIGH',a.free_mb/3) usable_mb,
count(b.path) cdisks
from v$asm_diskgroup a, v$asm_disk b
where a.group_number=b.group_number
group by a.name,a.total_mb,a.free_mb,a.type,
decode(a.type,'NORMAL',a.total_mb/2,'HIGH',a.total_mb/3) ,
decode(a.type,'NORMAL',a.free_mb/2,'HIGH',a.free_mb/3)
order by 2,1
/