How to check FRA ( Fast Recovery area) Utilization in Oracle ?

by

Hey 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.

1
2
3
4
5
6
7
8
9
10
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
1
2
3
4
5
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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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 !! 🙂