Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
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….
