Best Practices for Oracle E-Business Suite Performance Tuning
Isam Alyousfi and Lester Gutierrez are key members of our Applications Performance Group. They recently presented their popular session covering performance tuning tips for all layers of the E-Business Suite at OAUG/Collaborate earlier this year. [...] This presentation is chock full of tips, pointers, and hard-won knowledge. It represents the distillation of countless performance-related Service Requests and customer escalations. If you’re grappling with performance issues in your environment, or simply trying to squeeze more performance out of existing hardware, I’d strongly recommend downloading this presentation.
Tuning All Layers Of E-Business Suite – Performance Topics
Comments Off | Filed in Oracle | Tags: EBS, performance, presentationJoin factorization, a new Oracle DB 11gR2 feature
Hong Su from Inside the Oracle Optimizer:
The Join Factorization transformation was introduced in Oracle 11g Release 2 and applies to UNION ALL queries. Join factorization is a cost-based transformation. It can factorize common computations from branches in a UNION ALL query which can lead to huge performance improvement.
Yet another reason to upgrade to 11gR2.
Comments Off | Filed in Links, Oracle | Tags: performance, sqlOracle Performance Monitoring in Less than 12 Minutes (Video)
In this two part video, Stephane Faroult talks about “the basics of Oracle Performance Monitoring, and how you can get fancy (and even useful) reports without spending a fortune”. Stephane also demonstrates “how to install the (free) statspack utility and how some web resources can help you generate the reports you need for proactive monitoring”.
2 Comments | Filed in Oracle | Tags: performance, videoRewriting SQL Queries for Performance in 9 Minutes (Video)
Here is another video from Stephane Faroult about how you can improve query performance:
3 Comments | Filed in Oracle | Tags: database, performance, sql, videoNorthwest Oracle Users Group (NWOUG) 2006 Fall Conference
When was the last time you did not use a computer for one full day? My last time was yesterday and it was not because I was on vacation. Yesterday, I was in the Northwest Oracle Users Group (NWOUG) 2006 Fall Conference.
I attended six 45-minute presentations. The sessions that were interesting and that I liked most were the one presented by Dan Morgan: The Hidden Jewels in 10g, and the one presented by Cary Millsap: Accountability for System Performance. Dan did not use PowerPoint (which is good because I do not like watching slides while at the same time listening to the presenter reading the slides, I like the “real” thing), he actually fired up his SQLPlus and demonstrated a few really cool, useful and some undocumented Oracle 10g SQL features, which I will be blogging about soon. I also liked Cary Millsap’s presentation mainly because the subject that he talked about was really interesting.
In the conference, I also bumped into Jared Still. Jared and I used to work for the same company before we both moved on to different employers, but still in the same neighborhood. Even though we worked for the same employer, we were not in the same department. After all, Jared is a DBA and I am a developer 
.
How do you use tkprof to solve a performance problem?
In his latest article, Jonathan Lewis uses tkprof to analyse the performance of a query. He concluded that “When you examine the output from tkprof, it often takes a simultaneous cross-check of the block level statistics, the Row Source Operation counts, and some sensible guesswork about the purpose of the query, to be able to understand where the problem is, and how it may be addressed.” Read Jonathan’s interesting article: An example of making sensible guesses from a tkprof output.
2 Comments | Filed in Oracle | Tags: performance, tkprof, tuning
