Re: tuning sql queries....
From: Jeremy Schneider <jeremy.schneider_at_ardentperf.com>
Date: Tue, 06 Sep 2011 08:26:27 -0500
Message-ID: <4E661F83.6060301_at_ardentperf.com>
If you're comparing two environments where the same SQL statement runs differently, then the very first thing I'd look at is whether the SQL statements are using the same plan. The other first thing you need to check is what the differences are between the two environments... both in terms of hardware/software environment and data (as Chris has pointed out).
Date: Tue, 06 Sep 2011 08:26:27 -0500
Message-ID: <4E661F83.6060301_at_ardentperf.com>
If you're comparing two environments where the same SQL statement runs differently, then the very first thing I'd look at is whether the SQL statements are using the same plan. The other first thing you need to check is what the differences are between the two environments... both in terms of hardware/software environment and data (as Chris has pointed out).
-J
On 9/6/2011 7:59 AM, Zabair Ahmed wrote:
> I've just been given some trace files, to examine as to why a piece of sql is taking a long time to run in one evironment and not taking so much time in another environment.
>
> Both the databases are running 11.2.0.1 on AIX 6.1 - am also told that the databases are running on the same SAN.
>
>
> First piece of SQL......
-- http://www.ardentperf.com +1 312-725-9249 Jeremy Schneider Chicago -- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 06 2011 - 08:26:27 CDT