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_at_yahoo.com>:
>
> 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
Received on Wed Jul 05 2006 - 14:46:18 CDT
