How do you know you was running out of space in rollback segment? ORA-1555?
Usually, SELECT fails with ORA-1555 not because rollback segment is
too small but because your undo retention period is too small. I
assume you use automatic undo management.

2006/7/5, A Joshi <ajoshi977@(protected)>:
>
> Hi,
>   I had a big query which was running out of rollback so after some tuning
> i had to break it down in to two. from the first query i store the result in
> a temporary table and then use it for second part. it is still slow. i did
> not use permament table since that could involve rollback/redo. but still i
> will try to check it. i am also thinking of pl/sql table but if that always
> remains in memory then it could impact memory or sga. pl/sql table uses pga
> or OS memory but if paging swapping occurs then it would impact sga too.
> Will it always be faster than temp or permanent table? Can some one give
> feedback if you had similar experience. Thanks for help.
>
>
> ________________________________
> Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates
> starting at 1?/min.
>
>


--
Best regards,
Alex Gorbachev

http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l