Re: tuning sql queries....
- From: Jeremy Schneider <jeremy.schneider@xxxxxxxxxxxxxx>
- To: roon987@xxxxxxxxxxx
- Date: Tue, 06 Sep 2011 08:26:27 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
