Fast Recovery Area (FRA)

Fast Recovery Area (FRA)

Recovery area:

FRA Dest:--

sql>Show parameter reco


FRA usage:---

Col NAME for a40
SELECT NAME,ROUND(SPACE_LIMIT / 1024/1024/1024) SPACE_LIMIT_GB,ROUND(SPACE_USED / 1024/1024/1024) SPACE_USED_GB,
ROUND(((SPACE_USED / 1024/1024/1024) * 100) / (SPACE_LIMIT / 1024/1024/1024), 2) PRC_USED
FROM V$RECOVERY_FILE_DEST;




Archive log count--

SELECT TO_CHAR (COMPLETION_TIME, 'DD/MM/YYYY') DAY,COUNT (*) TOTAL
    FROM V$ARCHIVED_LOG
WHERE ARCHIVED='YES'
GROUP BY TO_CHAR (COMPLETION_TIME, 'DD/MM/YYYY')
ORDER BY TO_DATE (DAY, 'DD/MM/YYYY');
Archive log  size
SELECT SUM_ARCH.DAY,
         SUM_ARCH.GENERATED_GB,
         SUM_ARCH_DEL.DELETED_GB,
         SUM_ARCH.GENERATED_GB - SUM_ARCH_DEL.DELETED_GB "REMAINING_GB"
   FROM (  SELECT TO_CHAR (COMPLETION_TIME, 'DD/MM/YYYY') DAY,
                   SUM (ROUND ( (blocks * block_size) / (1024 * 1024 * 1024), 2))
                      GENERATED_GB
              FROM V$ARCHIVED_LOG
             WHERE ARCHIVED = 'YES'
          GROUP BY TO_CHAR (COMPLETION_TIME, 'DD/MM/YYYY')) SUM_ARCH,
         (  SELECT TO_CHAR (COMPLETION_TIME, 'DD/MM/YYYY') DAY,
                   SUM (ROUND ( (blocks * block_size) / (1024 * 1024 * 1024), 2))
                      DELETED_GB
              FROM V$ARCHIVED_LOG
             WHERE ARCHIVED = 'YES' AND DELETED = 'YES'
          GROUP BY TO_CHAR (COMPLETION_TIME, 'DD/MM/YYYY')) SUM_ARCH_DEL
   WHERE SUM_ARCH.DAY = SUM_ARCH_DEL.DAY(+)
ORDER BY TO_DATE (DAY, 'DD/MM/YYYY');