As some may know Oracle resently realised RDBMS 12.1.0.2 version, which features, among others, IN-MEMORY option. So I disided to test how it works, and what benefits would it give if deployed to production. TestLab configuration On host with VMWare ESXi 5.0 I created v irtual machine of 4 cpu cores and 8Gb RAM. Operating system used was Oracle Linux 6.5. Database server - ofcourse Oracle EE 12.1.0.2 Instance was configured with following parameters: sga_max_size big integer 6G sga_target big integer 6G pga_aggregate_limit big integer 1057M pga_aggregate_target big integer 800M inmemory_size big ...