Re: tuning sql queries....
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: roon987@xxxxxxxxxxx
- Date: Tue, 6 Sep 2011 08:27:35 -0600
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.
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
