Re: Enable 32K Block in 8K Block DB

"Douglas Hawthorne" <douglashawthorne_at_yahoo.com.au> wrote in message news:<c1K9c.128954$Wa.107656_at_news-server.bigpond.net.au>...
> "Charles" <cdavis10717_at_comcast.net> wrote in message
> news:83dbb3cd.0403281556.43addf38_at_posting.google.com...
> > All,
> >
> > How do I enable a 32K block size in a database that was created with
> > 8K block originally under Oracle 8.1.7.4.0?
> >
> > I want to have different block sizes for tablespaces in this database,
> > which is now Oracle 9.2.0.4.0 on AIX.
> >
> > I'm thinking of doing these steps.
> >
> > 1. Backup Controlfile to trace. Shutdown.
> > 2. Alter init.ora to specify 32k block size.
> > 3. Add init.ora parmeters for 8k cache size.
> > 4. Startup Oracle and recreate/reuse the database with the backup
> > controlfile to trace.
> >
> > Too simple?
> >
> > What are the real steps to follow?
> >
> > Many thanks.
> >
> > Charles
>
> Charles,
>
> Do you want to change the default block size for the database? If so, why?
>
> Why not just enable the use of 32K block size while retaining the default
> block size of 8K? This is the most simple way.
>
> If you want to enable the use of 32K block size, try the following (or use a
> larger size than 4M if you so desire):
> ALTER SYSTEM SET db_32k_cache_size=4M;
> This can be done while the server is running. Then you can start creating
> 32K block size tablespaces.
>
> Douglas Hawthorne

Thank you for replying, Douglas.

The parm "db_32k_cache_size" is invalid in a 8K blocksize db; Oracle won't let you set it. I've already tried this.

Charles Received on Mon Mar 29 2004 - 07:19:15 CST