You may have noticed the "About this Page" link in the lower left of your R12 pages. If you haven't, I'll tell you how to make it appear.

 

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?

 

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.

 

Upgrading to R12 of Oracle EBS is on the horizon or already in the pipeline for a great deal of existing 11i customer. The first question is upgrade vs.re-implement. The sheer amount of information available around these two options, recommended approaches, pros and cons etc. is overwhelming.

 

Upgrading to R12 of Oracle EBS is on the horizon or already in the pipeline for a great deal of existing 11i customer. The first question is upgrade vs.re-implement. The sheer amount of information available around these two options, recommended approaches, pros and cons etc. is overwhelming.

 

What is SQL Monitoring?

Starting with 11g, Oracle introduced a new tool to add to the performance optimizer’s toolkit called “Real Time SQL Monitoring”.  Real Time SQL Monitoring, or just “SQL Monitoring”, enables you to measure the performance of SQL statements while they are executing.  SQL Monitoring is enabled any time a statement runs in parallel or when it consumes more than 5 seconds of CPU or IO time.

 
What is Oracle’s Execution Plan?

An Oracle execution plan is a detailed set of steps showing how Oracle will access the requested data.

 
Oracle has waived the extended support fee for E-Business Suite 11i again and this time until November 2013.  This extension now spans the entire three years of the Extended Support period, December 2010 – November 2013. This is a two-year extension to the initial waiver for the first year of the Extended Support fees. 

This is great news for many customers who want to maximize their investment from their ERP implementations while planning on a Release 12 or Fusion Applications upgrade or implementation later in the Release 11i Extended Support period. 

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