O'Reilly logo

Oracle 11g R1/R2 Real Application Clusters Essentials by Syed Jaffer Hussain, Ben Prusinski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required