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