Many thanks to all of those who replied. The consensus is that AdvFS has a
block size of 8KB, and that UFS can be as low as 512 bytes, but that my DBAs
should use 8KB for their blocksize.
A few also reminded me that Oracle 8.1.7 and higher no longer supports
processors prior to the EV5.6. Our 2100A had been upgraded to EV5.6
processors (though we learned this the hard way on our other 2100 which had
the EV4 processors).
Thanks again,
John Losey
-----Original Message-----
From: John Losey [mailto:JLosey_at_Solucient.com]
Sent: Friday, February 22, 2002 1:19 PM
To: Tru64 UNIX Managers Group (E-mail)
Subject: "OS Block Size"?
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 Mon Feb 25 2002 - 18:22:38 NZDT