flashback logs not getting cleared 12.1.0.2

Posted by satish on Apr 05, 2021; 3:49am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/flashback-logs-not-getting-cleared-12-1-0-2-tp9571.html

Dear Erman,

Our dbversion 12.1.0.2

We have allocated 150G space for flash recovery area and rention target is 8 hours.We have dedicatedly provided 150GB to flashback logs.This is what we see

SELECT
  2    ROUND((A.SPACE_LIMIT / 1024 / 1024 / 1024), 2) AS FLASH_IN_GB,
  ROUND((A.SPACE_USED / 1024 / 1024 / 1024), 2) AS FLASH_USED_IN_GB,
  ROUND((A.SPACE_RECLAIMABLE / 1024 / 1024 / 1024), 2) AS FLASH_RECLAIMABLE_GB,
  SUM(B.PERCENT_SPACE_USED)  AS PERCENT_OF_SPACE_USED
FROM
  V$RECOVERY_FILE_DEST A,
  V$FLASH_RECOVERY_AREA_USAGE B
  3    4    5    6    7    8    9  GROUP BY
  SPACE_LIMIT,
  SPACE_USED ,
  SPACE_RECLAIMABLE ; 10   11   12

FLASH_IN_GB FLASH_USED_IN_GB FLASH_RECLAIMABLE_GB PERCENT_OF_SPACE_USED
----------- ---------------- -------------------- ---------------------
        150           149.86                83.15                  99.9




PERCENT_OF_SPACE_USED is 99.9%.Instance is running but we are afraid it may hang the database,so every time we are running below commands to get the flashback logs deleted.

alter database flashback off;
alter database flashback on;

Is there any alternative,or will it clear the flashback logs after it reaches 100%?

Thanks,
Satish.G