Friday, August 15, 2008

ASM diagnostics statements.

SELECT GROUP_NUMBER, DISK_NUMBER, TOTAL_MB/1024 total, free_mb/1024 used, NAME FROM v$asm_disk;

select group_number, name, total_mb/1024 total_gb, free_mb/1024 free_gb
from v$asm_diskgroup;

select type, sum(bytes) from v$asm_file group by type;