You are both right and wrong. Yes the db block size has to be at least as
big as an OS block size, it could not be otherwise. However tablespace block
size is exactly equal to the db block size, after all the oracle blocks are
stored in the datafiles which make up the tablespaces.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Harris Ruan" <h_ruan_at_totalise.com.au> wrote in message
news:EcTv6.10$mk.102501_at_news.interact.net.au...
> Thanks for the input but I am sure database block size shall be at least
as
> large as your operating system block size. I don't think it has anything
to
> do with the tablespace block size here.
>
> > It is the block size of your tablespaces ... not of the O/S.
> >
> > Look in your init.ora file.
> >
> > Daniel A. Morgan
> >
>
>
Received on Tue Mar 27 2001 - 04:14:04 CST
