How to Check FRA Usage in Oracle Database

Question

319 views20/04/2023Oracle Database

0

Amen1.09K 18/04/2023 0 Comments

How to Check FRA Usage in Oracle Database? DBA scripts to Check FRA Usage in Oracle Database?

Ezana Answered question 20/04/2023

Write your answer.

score 0 · Answer 1 · 2023-04-20T08:36:23+00:00

DBA scripts to query FRA Usage in Oracle Database:

SELECT ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1) AS PERCENT_FULL FROM V$RECOVERY_FILE_DEST;