Re: performance question

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:
> http://forums.oracle.com/forums/thread.jspa?messageID=2549168&#2549168

And for the 10053 there is a nice paper linked at http://www.centrexcc.com/papers.html

Kind regards

        robert Received on Wed Nov 12 2008 - 14:45:14 CST