Block Size Question

From: <g.renfrew_at_acca.org.uk>
Date: Thu, 08 Jul 1999 15:46:51 GMT
Message-ID: <7m2h57$eqo$1@nnrp1.deja.com>

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 - 10:46:51 CDT