flashback information not deleted
The Flashback log is 85% Full, and it goes back to 27-JAN-14, yet the retention is set to only 240 minutes.
SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;
-- FLASHBACK LOG 84.19 0 183
SELECT ESTIMATED_FLASHBACK_SIZE,FLASHBACK_SIZE,OLDEST_FLASHBACK_SCN,OLDEST_FLASHBACK_TIME FROM V$FLASHBACK_DATABASE_LOG;
-- 1657778176 110326972416 6005387329 27-JAN-14
SHOW PARAMETERS FLASHBACK;
--db_flashback_retention_target integer 240
Why is the flashback not reducing?
0