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
OLTP
The purpose of this blog is to show how different performance strategies can be implemented using the Oracle Database Resource Manager. Some practical examples are looked at to illustrate the point.
Resource Manager is designed to maximize throughput, so the resource plan directive given is no hard limit. In a CPU constrained system, we can allocate more CPU resources to OLTP users than to batch-jobs. With Resource Manager, the DBA can plan for a more proactive and predictable performance perspective – meeting service level agreements.