Re: Change db_block

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sat, 13 Oct 2001 16:08:57 +1000
Message-ID: <3bc7da40@news.iprimus.com.au>

Correct, but SYSTEM and TEMPORARY tablespaces can only be of the block size that you started with.

You also have to ask yourself whether the multiple block sizes feature is actually of any real benefit, apart from making transportable tablespaces a useful feature. First, there's no keep or recycle pools for new block sizes, only for the one you started out with. And second, there *is* a "correct" block size for your operating system and file system, and picking any other one will impact on performance.

Regards
HJR

--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================


"Fred Pierce" <fpierce_at_avialantic.com> wrote in message
news:3BC6DED2.D1284EF0_at_avialantic.com...


>

>

> "Howard J. Rogers" wrote:

> >

> ...

>

> > In 9i, you have the option to add in tablespaces of different block

sizes


> > than the one you started out with, but that probably isn't what you're

> > after.

> >

> > Regards

> > HJR

>

> Do I read correctly that you could then move objects to the new

> tablespaces and drop the old tablespaces with the old block sizes?

>

> fdp

>

> --------------------------------------------

> Fred Pierce (DNRC) Oracle

> Avialantic.com fpierce_at_avialantic.com

> www.avialantic.com

> MAAM WWII Weekend Airshow 2002 - June 7-9

> MAAM Transportation Show 2002 - Sept. 21-22

> www.maam.org/transhow.html

> -------------------------------------------

>

> >

> > "Tuan Dang" <tdang1_at_slb.com> wrote in message

> > news:9q4hsc$m8h$1_at_news.sinet.slb.com...

> > > Hello,

> > >

> > > Does anybody know how to change the oracle parameter db_block_size?

> > >

> > > Thanks,

> > > Tuan

> > >

Received on Sat Oct 13 2001 - 01:08:57 CDT

Re: Change db_block_size