Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ** temp table or permanent

Re: ** temp table or permanent

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Wed, 5 Jul 2006 21:46:18 +0200
Message-ID: <c2213f680607051246u379f7420t9c436e88541eb91e@mail.gmail.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US