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

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

** temp table or permanent

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Wed, 5 Jul 2006 07:43:28 -0700 (PDT)
Message-ID: <20060705144328.84101.qmail@web60714.mail.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.
--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 05 2006 - 09:43:28 CDT

Original text of this message

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