dbca & non-standard block sizes

From: Nicolas Mailhot <Nicolas.Mailhot_at_laposte.net>
Date: Thu, 13 Jan 2005 11:34:23 +0100
Message-ID: <pan.2005.01.13.10.34.23.267345@laposte.net>

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 ?

Regards,

-- 
Nicolas Mailhot

Received on Thu Jan 13 2005 - 04:34:23 CST