Blog

Oracle E-Business Suite, Exadata, and Smart Scan

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. What is Smart Scan? Smart Scan is probably the most important software feature on Exadata with respect to being […]

Read More

Extracting Average Active Sessions from ASH

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: http://karlarao.wordpress.com/2010/07/25/graphing-the-aas-with-perfsheet… www.perfvision.com/papers/02_asl_golden_metric.ppt https://sites.google.com/site/embtdbo/wait-event-documentation/aas—ave… You can obtain AAS data from the main Enterprise Manager performance page, as well as by running an ASH report.  But […]

Read More

“About This Page” – Part 1

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. If you’re anything like me, you hardly have time to stop what you’re doing to find a new clever way to do things; however, spending some time […]

Read More

Auto DOP, Cell Offload, and Oracle EBS

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.02 APPS @ visx1> […]

Read More

Automatic DOP and Oracle EBS

What is Auto DOP? Starting with 11g, Oracle introduced Automatic Degree of Parallelism, or Auto DOP.  I’ve blogged about this at https://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 […]

Read More

Business Impacts of an EBS R12 upgrade

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. There are some common themes one should consider when […]

Read More

Business Impacts of an EBS R12 upgrade

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. There are some common themes one should consider when […]

Read More

Oracle 11gR2 SQL Monitoring

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 […]

Read More

Execution Plans, Partitioning, and Parallelism in Oracle

What is Oracle’s Execution Plan? An Oracle execution plan is a detailed set of steps showing how Oracle will access the requested data. When a SQL statement runs, the parsed execution plan is stored in a view called V$SQL_PLAN.  Knowing how to read an execution plan is very important for developers and DBAs alike in […]

Read More

Oracle Waives Extended Support Fees for Entire Three Years on E-Business Suite 11.5.10

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 […]

Read More

Whatever we ask them to do, we know they'll deliver a solution and not leave us hanging.

Tony Deller Manager Data Center Technical Engineering