Forum Stats

  • 3,874,727 Users
  • 2,266,768 Discussions
  • 7,911,961 Comments

Discussions

Dynamic occupation threshold for start purging the recovery area

Peter_L_
Peter_L_ Member Posts: 135 Bronze Badge
edited May 25, 2016 5:03AM in Database Ideas - Ideas

If you use OMF and a recovery area for example for standby archivelogs at a physical standby database and the archivelog deletion policy is set with:

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;

there is an static percental threshold (I read something arround 95%), from where automatic purging of archivelogs and other FRA objects occurs.

I assume, if the recovery area size is to small  (due resource gap), it will be better to start purging  already at 50%.  So it is more time for applying archivelogs and purging obsolete in high load situations.

So my wish is to have this threshold dynamicly changeable or Oracle calculates this threeshold adaptiv, for example based on DB_RECOVERY_DEST_SIZE and transaction rate.

Regards Peter

Peter_L_Sven W.Hemant K ChitaleTom321berx
6 votes

Active · Last Updated

Comments