Tag: flashback

Extending Flashback Data Archive in 12c

Flashback Data Archive (previously called Total Recall) has been around for a long time now. For those unfamiliar with it, (and by the way, if you are on Enterprise Edition, you should be familiar with it, because its a free feature), here is a…

ORA-65131 grrrr

So…the future is container databases ? Cool ! I’ll create all my databases as container databases….I’m so happy….until SQL> CREATE FLASHBACK ARCHIVE longterm TABLESPACE demo RETENTION 1 MONTH; CREATE FLASHBACK ARCHIVE longterm TABLESPACE demo RETENTION 1 MONTH * ERROR at line 1: ORA-65131: The…

Lob CACHE vs NOCACHE – impact on flashback logging

I was doing some work for a client, and LOB processing seemed incredibly slow. After some poking around, it appears that LOB processing is quite sensitive when it comes to flashback mode in the database. Test bench is a simple table with three clobs….