check Oracle DB FRA and DISKGROUP Usage
نشر بواسطة : Obay Salah , December 22, 2024
1- Check fast recovery area usage
select name,round(space_limit / 1024 / 1024 /1024) size_gb ,round(space_used / 1024 / 1024/1024) used_gb, decode(nvl(space_used,0),0,0,round((space_used/space_limit) * 100)) pct_used from v$recovery_file_dest order by name;
2- Check ASM DISKGROUP usage
select name, total_mb, free_mb, usable_file_mb,round(((total_mb-nvl(free_mb,0))/total_mb)*100,0) percent_used from V$ASM_DISKGROUP_STAT;
or
select NAME,TOTAL_MB/(1024) TOTAL_GB,FREE_MB/1024 FREE_GB,(TOTAL_MB-FREE_MB)/1024 USED_GB,(FREE_MB/TOTAL_MB)*100 FREE_PER from v$asm_diskgroup;
Comments
لايوجد تعليق حتى الان