Enabling Flashback – Be Cautious

Enabling flashback on 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 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