5+ fold performance degradation due to enabled flashback

Hi,

BTW this is on Exadata 11.2.0.3.

When doing a relatively simple insert append into a table there is a 5 to 7 fold performance degradation when flashback is enabled.

About 6 million rows are inserted into an empty table with a primary key and 1 other unique index.

When flashback is not enabled the tkprof output looks like :

call     count cpu    elapsed       disk query    current        rows

------- ------  -------- ---------- ---------- ---------- ----------  ----------

Parse        1 0.00       0.00          0          0          0           0

Execute      2 42.57      43.46          9 372928    2741017     6450171

Fetch        0 0.00       0.00          0          0          0           0

------- ------  -------- ---------- ---------- ---------- ----------  ----------

total        3 42.58      43.47          9 372928    2741017     6450171

Misses in library cache during parse: 1

Optimizer mode: ALL_ROWS

Parsing user id: 79

Number of plan statistics captured: 1