fast_recovery_area keeps growing very fast
Hi All,
I need suggestion, How can I better manage the fast_recovery_area of my database, as it get full very frequently.
I have set the size of my FRA as 48 G, current utilization is given below. However I see the datafiles size as culprits.
=============================
SQL> select SPACE_LIMIT from V$RECOVERY_FILE_DEST;
SPACE_LIMIT
-----------
5.1540E+10
SQL> select SPACE_USED from V$RECOVERY_FILE_DEST;
SPACE_USED
----------
4.6903E+10
==========================
[oracle@XXXXX DEVELOP11]$ df -kh
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_system-lv_root
29G 13G 16G 45% /
tmpfs 1.5G 766M 679M 54% /dev/shm
/dev/sda1 477M 194M 258M 43% /boot
2