Re: Block Size Question

Oracle's Default Block Size is 2K irrespective of Solaris Block Size. You should be sizing the Oracle Block Size depending upon U'r Application viz OLTP, OLAP etc .

I would suggest a Block Size of 2K or 4K for OLTP and 4K or 8K or even 16K for DataWarehousing Applications and not decide based on the OS Filesystem Block Size..

-Thiru

g.renfrew_at_acca.org.uk wrote:

> Hi All,
>
> I've a question about the db_block_size param.
>
> Running 7323 on Solaris 2.6.
>
> Solaris 2.6 NFS block size is 8K (as returned by the command "echo :sb
> | fsdb /dev/md/dsk/d50 | grep \^bsize | cut -f2"). Assuming this is
> correct, should my default DB_BLOCK_SIZE be 8K also?
>
> I have created a database from scratch on this machine, with the
> db_block_size param not set - so I expected the size default to 8K.
> However, after some simple calculations on bytes / blocks on
> dba_segments I get the db_block_size to be 2K.
>
> This tells me either my method of working out the Solaris block_size is
> way off or something somewhere is setting the db_block_size to be other
> than the default.
>
> Are my calculations correct, or am I working out the FS block size
> incorrectly.
>
> Thanks
>
> Graeme Renfrew
> DBA
> ACCA Glasgow, UK
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Jul 08 1999 - 14:50:12 CDT