Press Summary
Auto DOP, Cell Offload, and Oracle EBS
January 30th, 2012
Written by John Clarke
 Imagine you've recently migrating your Oracle e-Business Suite to Exadata, and you've decided to implement automatic degree of parallelism, or Auto DOP. How does this impact Smart Scan? Let's test by first ensuring that our Auto DOP is set to MANUAL: APPS @ visx1> alter system set parallel_degree_policy=MANUAL;       System altered. Elapsed: 00:00:00.02APPS @ visx1> alter system flush shared_pool; System altered. Elapsed: 00:00:00.04APPS...
Read More →
Automatic DOP and Oracle EBS
January 30th, 2012
Written by John Clarke
 What is Auto DOP?Starting with 11g, Oracle introduced Automatic Degree of Parallelism, or Auto DOP.  I’ve blogged about this at http://www.centroid.com/knowledgebase/blog/automatic-degree-of-parallelism-in-oracle-11gr2.  I’m not going to review all the ins and outs of Auto DOP in this post.  Here, I’ll talk about a few things specific to Oracle e-Business Suite that are worth noting. Enabling Auto DOP: First Tests          ...
Read More →
Automatic Degree of Parallelism in Oracle 11gR2
November 29th, 2011
Written by John Clarke
What is Parallel Execution?At a very high level, parallel execution is a means for Oracle to “divide and conquer” the process of fetching data Oracle tables.  See http://docs.oracle.com/cd/E14072_01/server.112/e10837/parallel.htm#CACEEBJJ. Parallel execution in Oracle allows a single database operation to apply multiple CPU and IO resources (i.e., processes) to work together to retrieve the results.  Parallel execution is often a desirable goal when and if:A large amount of data...
Read More →