With Oracle Database 12.1.0.2, Oracle has released its In-Memory Database functionality. In short, Oracle In-Memory database provides transparent column-format memory access over an existing Oracle database. The normal row-format memory access is preserved for fast OLTP transactions; however, with new system parameters, that same data can be accessed from memory in column-format, drastically improving OLAP performance. Because it is transparent, there is no need to change applications to leverage this new functionality, which had previously only been exposed in engineered systems and ZFS as storage-level optimizations.
Viewing entries tagged
OLAP
A great feature introduced in the Oracle 11g database is the SQL query ‘Result Cache’. A result cache is an area of memory that stores the results of a database query or query block for reuse. The cached rows are shared across SQL statements and sessions unless they become stale. The caching mechanism is efficient and easy to use, and it relieves you of designing and developing your own legacy cache procedures and cache-management policies.