Re: Create 12c or 18c database in traditional architecture

Total Recall is actually a pretty good feature, and can do more than you will get from offloading stuff to a DW. Not only can you do all the undo-based flashback operations for extended periods of time with it, but you can also see the application context values that were present when that data was modified. It can be a good replacement for the custom application auditing (history tables) people often put in place in their applications.

Bjoern Rost does a talk where he uses this feature for change data capture in conjunction with Kafka. It's pretty cool.

The mistake was making it use advanced compression, which made the advanced compression option mandatory. Making that optional made it available to the rest of us. I would be interested to know if someone thought this feature alone would push advanced compression licenses, which I'm sure it didn't, or if it was just a bad choice that got changed later...

Cheers

Tim...

--
http://www.freelists.org/webpage/oracle-l