My Oracle DBAs are saying that their tuning guides say to set the block size
of their databases as multiples of the "OS Block Size" and that this value
is OS dependant. We're got running Tru64 4.0f & 5.1A servers using AdvFS
for most of our Oracle data filesystems (though a couple of servers have UFS
filesystems for their Oracle files). We're trying to get Oracle 8.1.7.3 to
install and run on an AlphaServer 2100A with a fresh install of Tru64
5.1A+PK1, so I'm trying to squeeze as much blood out of the turnip as
possible and am looking at any options that might make it run faster.
How can I determine this value for my UFS & AdvFS filesystems? Or is it
just the 512bytes/block that is talked about in disklabel?
Thanks,
John Losey
Received on Fri Feb 22 2002 - 21:19:59 NZDT