Re: LOB columns and migrated rows

From: hitender chugh <chughhk_at_hotmail.com>
Date: Fri, 03 Feb 2006 11:08:46 -0500
Message-ID: <BAY105-F5160FED394CB1DE225CF2BD0D0@phx.gbl>

http://www.dba-oracle.com/art_dbazine_9i_multiblock.htm

In this article the same author has discussed mutiple block sizes/buffers to reduce I/O and chaining and other issues. I want to know people's suggestions on this to mitigate chaining and boost I/O

Thanks

From:  Joseph Amalraj <joseph@amalrajinc.com>
Reply-To:  joseph@amalrajinc.com
To:  oracle-l@freelists.org
Subject:  Re: LOB columns and migrated rows
Date:  Fri, 3 Feb 2006 07:53:38 -0800 (PST)

Mladen Gogala <gogala@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 - 10:08:46 CST