How to check FRA ( Fast Recovery area) Utilization in Oracle ?
1 min readHey Folks ,
As a DBA, performing routine checks for fast recovery are (FRA) monitoring is a fundamental task. Here are some scripts that can assist in monitoring tablespace usage within the database.
SELECT NAME,
ROUND(SPACE_LIMIT / 1048576 / 1024 ) SPACE_LIMIT_GB,
ROUND(SPACE_USED / 1048576 /1024 ) SPACE_USED_GB,
ROUND(SPACE_LIMIT / 1048576 / 1024 ) - ROUND(SPACE_USED / 1048576 /1024 ) SPACE_USABLE_GB,
CEIL(((SPACE_USED / 1048576) * 100) / (SPACE_LIMIT / 1048576)) PRC_USED FROM V$RECOVERY_FILE_DEST;
NAME SPACE_LIMIT_GB SPACE_USED_GB SPACE_USABLE_GB PRC_USED
-------------------------------------------------- -------------- ------------- --------------- ----------
+DATA 150 48 102 33
select SPACE_USED/1024/1024/1024 "SPACE_USED(GB)" ,SPACE_LIMIT/1024/1024/1024 "SPACE_LIMIT(GB)" from v$recovery_file_dest;
SPACE_USED(GB) SPACE_LIMIT(GB)
-------------- ---------------
48.2470703 150
col name for a44
col size_m for 999,999,999
col used_m for 999,999,999
col pct_used for 999
SELECT name
, ceil( space_limit / 1024 / 1024) SIZE_MB
, ceil( space_used / 1024 / 1024) USED_MB
, decode( nvl( space_used, 0),
0, 0
, ceil ( ( space_used / space_limit) * 100) ) PCT_USED
FROM v$recovery_file_dest;
NAME SIZE_MB USED_MB PCT_USED
-------------------------------------------- ---------- ---------- --------
+DATA 153600 49405 33
Hope it helped !! 🙂
