ASM查看磁盘组使用率

Oracle查看ASM磁盘组使用率

 col name for a25
 set linesize 200
 select NAME,type,total_mb/1024 "total_gb",(total_mb-free_mb)/1024 "used_gb",free_mb/1024 "free_gb",((total_mb-free_mb)/total_mb)*100 "%used" from v$asm_diskgroup;