Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select statement tuning - help required
There is no difference in the plan on the remote site or the local
site or in the trace.
When I run the query in SQL Plus, I have observed that the query
starts returning rows very quickly i.e. in a few seconds, however as
the records spool, the rate at which they returned slows down and then
stops. After some time, I get an ORA-1555.
Can some one tell me how do I analyze this and if I have to make a
case of changing the retention period for UNDO how do I make that
case ?
Received on Wed Nov 07 2007 - 21:46:32 CST
![]() |
![]() |