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: LOB columns and migrated rows

Re: LOB columns and migrated rows

From: Joseph Amalraj <joseph_at_amalrajinc.com>
Date: Fri, 3 Feb 2006 07:53:38 -0800 (PST)
Message-ID: <20060203155338.94868.qmail@web315.biz.mail.mud.yahoo.com> 





Mladen Gogala <gogala_at_sbcglobal.net> wrote:
  


Multiple block sizes are normally used to plug in tablespaces from another database,
typically from an OLTP to DW. It's much faster then export and import. Multiple 
block sizes are practically useless for anything else.


-- 



Mladen Gogala


http://www.mgogala.com



    Had heard that using larger block sizes for index, will improve performance as per 
  http://searchoracle.techtarget.com/tip/1,289483,sid41_gci1008028,00.html
   


  Is having a larger block size set up for indexes only worthwhile.
   


  Thanks
   


  Joseph Amalraj




--



http://www.freelists.org/webpage/oracle-l




  




--



http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 03 2006 - 09:53:38 CST












Original text of this message













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