Re: Oracle 7.3.3 ---> Oracle 8 upgrade

Can you prove that increasing the blocksize will help ? It is a common misconception that 'big datatabases require big block sizes'

The last couple of datawarehouse jobs I got into were larger than 1TB raw data,
and one was almost certainly a prime candidate for a 2K blocksize, the other
was a toss-up between 2K and 4K.

Index strategies and phsyical data clustering have a significant effect on optimum
blocksize (unless memory is totally unlimited).

S V <sv1_at_mindspring.com> wrote in article <01bcf7b4$7111d7e0$3d5c0c26_at_sfinance3>...
>
> That's what we are contemplaiting
> to do on Christmas eve.
> The current size of database is about 100Gb.
> It runs on AIX 4.2 platform.
>
> I have some questions to the respectable Oracle
> community.
>
> 1. As part of the upgrade we also want to bump up
> db_block_size to at least 8k from current 4k.
> I personally would like to go to 16k block size
> since our db is purely data warehouse-style with
> quite big tables.
> Does Oracle 8 support block sizes > 8k ?
> 2. Apparently we would need to do full
> database export/import. What kind of
> problems should I expect with importing
> Oracle7.3.3 dump into Oracle 8 database?
> 3. Generally what kind of problems should
> I expect when going Oracle7.3 --> Oracle.8 ?
>
> Thanks,
> Serge
>
>
Received on Sun Nov 23 1997 - 00:00:00 CST