Re: help on a cursor/fetch

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 Sun Aug 29 1999 - 18:02:26 CDT