ODC Appreciation Day: Database In-Memory

This year I have been working mostly on Oracle Database In-Memory, so far have been impressed. As part of a project to move an analytical database to the cloud we have decided to use the In-Memory function. So far so good – it just works. Once the option is enabled a simple command loads the table into memory: Alter table w_expense_f inmemory priority critical; The columnar compression has worked really well for us, we have managed to get up to 85% compression on some tables. We are currently testing the performance against an exalytics system as well as TimesTen. So, watch this space