نشر بواسطة : 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;





علامات : Database

يمكن ان يعجبك ايضا


Comments

لايوجد تعليق حتى الان