First things First...
 
Most savvy Oracle performance folks know about the 10046 extended trace file. If not, just Google "10046 trace" and you'll learn all you need to know from a variety of sources.  Oracle's tkprof utility provides a means to read the trace file and provide meaningful output, and recently (10g+) it's had some nicer summary information on a per-cursor and per-session basis at the end of it.

 

You've taken the plunge and are planning on moving your Oracle EBS environment to Exadata.  In this post, I'll talk about some of the things you should think about with Oracle EBS and Exadata Smart Scan.

 

Average Active Sessions, or AAS is one of the most important metrics to look at from a database performance perspective.  There are many good resources that talk about AAS metrics, including:

 

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.