Database Administration (MOSC)

MOSC Banner

Flashback Data Archive - Oracle 19c

in Database Administration (MOSC) 4 commentsAnswered

Hello Everyone

We are implementing a project where we will be using the Oracle Flashback Data Archive feature. There will be a few tables that we will enable the FDA for with a retention time of 2 weeks

We wanted to ask how would that impact the size or the retention period of our UNDO tablespace? Do we need to tweak either the size of the UNDO TS or increase the undo retention (currently set to 900)

If we need to change either the UNDO TS size OR the Retention period how do we go about determining a good starting point?

Is it safe to assume that as soon as transaction is committed in the parent table, the changes will propagate over to the history tables right away but if there is huge gap in time between when the transaction start and when the commit was issued and during that time the undo blocks holding that changed data expired, we wont be able to capture the change?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center