Re: Change DB_BLOCK_SIZE

It is not a matter of 'reinstalling' it, so much as 'recreating' it.

The software is 'installed' and this stays unaffected.

What you need to do is

1 - Export any data from any database(s) affected.

2 - Drop the database (delete it).

3 - reCreate the database with a proven script.

4 - Then Import the exported data back into the new database.

Things to watch.

1. Make sure you have a good backup before you start
2. Remember to change the DB_BLOCK_SIZE as required
3. Remeber to adjust any block size affected parameter sizes in proportion to the Block Size change. I.e. to keep DB_BLOCK_BUFFERS the same divide the number by the factor the DB_BLOCK_SIZE was increased by.
4. Be prepared for lots of areas of the database to us more size / room. Redo, Rollback, System etc.

Regards

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United
Kingdom)
                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document
are not necessarily those of BOCM PAULS Ltd.
Duarte Nuno Sousa <Duarte.Sousa_at_solsuni.pt> wrote in message
news:38F194FB.73A651EB_at_solsuni.pt...


>

>

> I'm wondering if there is any other option to change de DB_BLOCK_SIZE in

> a DataBase without reinstaling all.

> I' m running Oracle 8.0.5, and i want to increse the DB_BLOCK_SIZE to

> 8k.

>

>

> Duarte Nuno de Sousa

> duarte.nuno_at_solsuni.pt

>