set linesize 220;
col failgroup for a15;
col name for a15;
col path for a25;
col used_percent for a10;
select t.failgroup,
t.name,
t.path,
round(t.TOTAL_MB / 1000) as total_gb,
round(t.FREE_MB / 1000) as free_gb,
round((t.TOTAL_MB - t.FREE_MB) / 1000) as used_gb,
round(((t.TOTAL_MB - t.FREE_MB) / t.TOTAL_MB) * 100, 2) || '%' as used_percent
from v$asm_disk t
order by t.failgroup,used_percent desc;
Oracle RAC查看ASM磁盘组、磁盘信息
于 2024-01-17 23:14:29 首次发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)