Re: LOB columns and migrated rows
- From: Joseph Amalraj <joseph@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 3 Feb 2006 07:53:38 -0800 (PST)
Mladen Gogala <gogala@xxxxxxxxxxxxx> 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
- Follow-Ups:
- Re: LOB columns and migrated rows
- From: hitender chugh
- Re: LOB columns and migrated rows
- From: Tanel Põder
- References:
- Re: LOB columns and migrated rows
- From: Mladen Gogala
Other related posts:
- » LOB columns and migrated rows
- » Re: LOB columns and migrated rows
- » Re: LOB columns and migrated rows
- » Re: LOB columns and migrated rows
- » Re: LOB columns and migrated rows
- » Re: LOB columns and migrated rows
- » Re: LOB columns and migrated rows
- » Re: LOB columns and migrated rows
- » Re: LOB columns and migrated rows
- Re: LOB columns and migrated rows
- From: hitender chugh
- Re: LOB columns and migrated rows
- From: Tanel Põder
- Re: LOB columns and migrated rows
- From: Mladen Gogala