Re: help on a cursor/fetch
Date: 1999/08/30
Message-ID: <935967690.21332.0.nnrp-09.c2de0af6_at_news.demon.co.uk>#1/1
Phil,
Investigate using Autotrace from SQLPLUS. or doing an alter session set sql_trace = true and then using tkprof on the output trace file.
This may help to pinpoint the problem
George Harding
Phil Chapman wrote in message ...
>Hi,
> I have a production problem which I cannot quite figure out. I have a
>join between two tables which produced a result set of ~300,000 rows,
within
>the program every fetch takes around 3 minutes. I have tried analyzing the
>tables with compute statistics on and recompiling the program using the sql
>but to no avail. I'm not even sure how I can progress in finding out the
>cause.
>
>Could it be potentially caused by a lack of space building the result set?
>
>Any help would be greatly appreciated.
>
>Thanks
>
>Phil
>
>
Received on Mon Aug 30 1999 - 00:00:00 CEST