Re: performance question
Date: Wed, 12 Nov 2008 21:45:14 +0100
On 12.11.2008 21:14, Charles Hooper wrote:
> On Nov 12, 2:42 pm, rogv <rvaede..._at_gmail.com> wrote:
>> I have a QA and PROD server and has loaded identical Oracle DB 10 >> i. >> This query runs fast on (10 Minutes) QA and slow on (3 hours) >> PROD. >> The servers are Red hat Linux.
Did you at least look at the execution plans? EXPLAIN PLAN can help a lot to quickly identify bad plans.
>> Both machines performance load are OK, production server load is a >> little high. >> What could possibly cause this performance difference?
SWAG: the high load.
> Enabling the traces:
> ALTER SESSION SET EVENTS '10053 TRACE NAME CONTEXT FOREVER, LEVEL 1';
> ALTER SESSION SET EVENTS '10046 TRACE NAME CONTEXT FOREVER, LEVEL 8';
> Decoding the 10046 portion of the trace file:
And for the 10053 there is a nice paper linked at http://www.centrexcc.com/papers.html
robert Received on Wed Nov 12 2008 - 14:45:14 CST