You plan to monitor the ASM configuration on an X5 Database Machine as part of your role supporting
Exadata-based ASM diskgroups.
You want to check for potential space problems that take ASM mirroring requirements into account.
Which two values would you monitor from V$ASM_DISKGROUP or by using the ASMCMD LSDG command?
A.
cold_used_mb
B.
total_mb
C.
required_mirror_free_mb
D.
free_mb
E.
usable_file_mb
Explanation:
Determine the Amount of Available Space
To increase the size of the disks in a disk group you must either have unallocated disk space available, or you have to reallocate space currently used by a different disk group.
Example: View the space currently used by the disk groups.
SELECT name, total_mb, free_mb, total_mb – free_mb used_mb, round(100*free_mb/total_mb,2) pct_free
FROM v$asm_diskgroup
ORDER BY 1;
<a href=”//static.equizzing.com/wp-content/uploads/1z0-070/Img7-4.jpg”><img class=”aligncenter size-full” src=”//static.equizzing.com/wp-content/uploads/1z0-070/Img7-4.jpg” alt=”” /></a>
The example above shows that the DATAC1 disk group has only about 15% of free space available while the
RECOC1 disk group has about 87% free disk space. The PCT_FREE displayed here is raw free space, not usable free space. Additional space is needed for rebalancing operations.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-administering-asm.htm#SAGUG20526