Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to tune Flashback Data Archive Process

Rajan SwOct 20 2020

Hi,
We have enabled FBDA for set of configuration tables apprx 70 tables.
There is a tool which pushes configurations to all these tables and that tool uses merge statements for all these configuration tables and updates.
Before BBDA, it takes around 1 min but once the FBDA is enabled it is taking more than 10 mins as lot of updations are happening . So is there any way to improve the performance.

We are currently using 12c R2

Comments
Post Details
Added on Oct 20 2020
2 comments
339 views