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 integer 512M HugePages was enabled for this installation. Configure in-memory ALTER SYSTEM SET INMEMORY_SIZE=512M SCOPE=SPFILE; SHUTDOWN IMMEDIATE; STARTUP; Total System Global Area 6442450944 bytes Fixed Size 2938792 bytes Variable Size