For quite some time, Oracle's kernel has been well-instrumented to capture detailed wait event information.  Google “Oracle wait events” and you’ll come up with a wide range of great papers and publications about Oracle wait events, and also see http://docs.oracle.com/cd/E11882_01/server.112/e16638/toc.htm.
 
Several cluster-specific wait events are populated in RAC environments.  
 
Oracle Database Appliance Installation
 
In this post I'm going to share  the end-to-end process of getting an Oracle Database Appliance (ODA) up and running at a client site.  No pictures, just words.   And right up front, I'm going to tell you this is likely going to be the shortest blog I'll ever post on www.centroid.com/knowledgebase.
 
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.