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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
