2007/12/05

ASM manage frequent used sql

usage of diskgroup:

select name, 1-free_mb/total_mb used_pct, free_mb, total_mb from v$asm_diskgroup where name like 'DG..%'


list rawdevice usage:

select to_number(substr(path, 13)) rawno, path, name, 1-free_mb/total_mb used_pct, free_mb, total_mb from v$asm_disk ad where name like 'DG01%' order by 1;

No comments: