Kirn Tailor is an Oracle Ace Associate, with extensive experience in Database Management, Performance and BI. At CIMA he is the Global Lead DBA/BI Solutions Architect. In this role he lead and manage CIMA's DBA functionality and 3rd party service providers in efficiently and effectively.
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