Re: tuning sql queries....
From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 6 Sep 2011 08:27:35 -0600
Message-Id: <547CD6A3-E7C7-4E82-8294-F244E16C9B8D_at_centrexcc.com>
In your "Second piece of SQL….." trace there is no execution plan ("Row Source Operation") only the explain plan. Why? Is the trace complete? Did it get cut short due to max_dump_file_size limit?
Date: Tue, 6 Sep 2011 08:27:35 -0600
Message-Id: <547CD6A3-E7C7-4E82-8294-F244E16C9B8D_at_centrexcc.com>
In your "Second piece of SQL….." trace there is no execution plan ("Row Source Operation") only the explain plan. Why? Is the trace complete? Did it get cut short due to max_dump_file_size limit?
Regards
Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com
On 2011-09-06, at 6: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.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 06 2011 - 09:27:35 CDT