We can check the FRA location using the following query:
1 2 3 4 5 6 7 8 9 10 11 12 13 | SQL> set linesize 500 col NAME for a50 SQL > select name, ROUND(SPACE_LIMIT/1024/1024/1024,2) "Allocated Space(GB)", round(SPACE_USED/1024/1024/1024,2) "Used Space(GB)", round(SPACE_RECLAIMABLE/1024/1024/1024,2) "SPACE_RECLAIMABLE (GB)" , (select round(ESTIMATED_FLASHBACK_SIZE/1024/1024/1024,2) from V$FLASHBACK_DATABASE_LOG) "Estimated Space (GB)" from V$RECOVERY_FILE_DEST;Example: NAME Allocated Space(GB) Used Space(GB) SPACE_RECLAIMABLE (GB) Estimated Space (GB) -------------------------------------------------- ------------------- -------------- ---------------------- -------------------- +FRA 400 .12 0 SQL> |
Amen Edited answer 14/04/2023