New performance features in Oracle 11gR2

Now, let's take a look at the new performance tuning features in Oracle 11g R2.

In-Memory Parallel Execution

In-Memory Parallel Execution utilizes aggregated memory in a system to optimize database query performance by reducing or eliminating physical I/O required for parallel operations. Oracle will automatically make a decision as to whether or not an accessed database object, which is using parallel execution, will benefit from being placed into the SGA buffer cache. For Oracle RAC, fragments of the object are mapped into each of the buffer caches on the active instances. These mappings allow Oracle to determine which buffer cache to access specific parts or partitions of the object to respond a granted ...

Get Oracle 11g R1/R2 Real Application Clusters Essentials now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.