Re: dbca & non-standard block sizes

Nicolas Mailhot wrote:
> Hi,
>
> We have several databases running under Linux and hosting Oracle
iFS/CMSDK
> data. iFS permits document storage in the database (including large
files
> like isos or DVD masters) so a typical iFS database is a mix of small
> tablespaces and huge dedicated lob tablespaces.
>
> It seems a textbook setup for using non-standard block sizes (4k for
the
> db and 32k for the lob tablespaces). Does anyone here have any
experience
> with such a thing? How would one write a dbca template with
non-standard
> block sizes ?

The textbook says you should be using the recycle pool, which you cannot do with non-standard block sizes. http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a88786/mm_dba.htm#615254

Also see the blocksize discursion at dizwell.com, as well as the recent discussion here about keep and recycle, and the one entitled "Enable 32K Block in 8K Block DB".

jg

--
@home.com is bogus.
D'Oh!
http://www.signonsandiego.com/uniontrib/20050113/news_1b13hacker.html