correct db_block_size and vxfs bsize?

From: <pat_2000_at_my-deja.com>
Date: Sat, 09 Sep 2000 04:48:15 GMT
Message-ID: <8pcfea$jt8$1@nnrp1.deja.com>

For an OLTP Oracle database, what is the correct config for db_block_size and the VxFS filesystem block size:

init.ora: db_block_size = 2048 mkfs -F vxfs -o bsize=2048 /dev/vx/rdsk/hostdg/vol#
init.ora: db_block_size = 2048 mkfs -F vxfs -o bsize=4096 /dev/vx/rdsk/hostdg/vol#
init.ora: db_block_size = 4096 mkfs -F vxfs -o bsize=2048 /dev/vx/rdsk/hostdg/vol#
init.ora: db_block_size = 4096 mkfs -F vxfs -o bsize=4096 /dev/vx/rdsk/hostdg/vol#

Thank you for the help.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 08 2000 - 23:48:15 CDT