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:
Post a Comment