Enabling Flashback – Be Cautious

Enabling flashback on 11.2.0.4 database can take minutes and cause multiple database wait events degrading database performance. On a quite busy system, during the low peak hours, I tried to enable flashback on 11.2.0.4.6 version database and multiple sessions waited on 1. buffer exterminate 2. enq: SQ - contention 3. latch: cbc contention 4. SGA: … Continue reading Enabling Flashback – Be Cautious