Daily Archives: April 6, 2015

Enable the In-Memory column store in database


SQL> select banner from v$version where banner like ‘%Database%’; BANNER ——————————————————————————– Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production SQL> select * from v$sgainfo where name=’In-Memory Area Size’; NAME BYTES RES CON_ID ——————————– ———- — ———- In-Memory Area Size 0 No 0 SQL> show parameter inmemory NAME TYPE VALUE ———————————— ———– —————————— inmemory_clause_default […]