Re: File system block size and page size

Frank van Bortel <fbortel_at_home.nl> wrote in message news:<3C222FDF.D2E36EA6_at_home.nl>...
> Marcco wrote:
> >
> > Hello,
> >
> > I can see that my HP-UX ufs file system is configured
> > to uses block size of 8k and page size of 4k.
> > My db_block_size is set equal to 4k (equal to page size).
> >
> > How I can resize this. What relation, between db_block_size and
> > page size. I want to increase this to 8k. Is this is possible?
> >
> > Thanks.
>
> Probably not without rebuilding the db; upto and including 8.1.7
> (aka 8i Rel3) block sizes were fixed, and set during db creation.
> As of 9 you can have different blocksizes for different tablespaces.
> Hint: always mention versions...

Thank you.

Im using Oracle 8i (8.1.6).
I have also some questions about: the relation between system block size, system page size and oracle db_block_size. Is increasing db_file_multiblock_read_count can replace db_block_size incresing knowing that my system block size is 8k and page size is 4k?

Thanks Received on Fri Dec 21 2001 - 11:41:14 CET