Re: Block Size Question

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 08 Jul 1999 21:12:42 +0800
Message-ID: <3784A3CA.638E@yahoo.com>

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.

I think it defaults to 2k on most Solaris versions....

...but I am pretty sure that 8k is the preferred...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jul 08 1999 - 08:12:42 CDT