Admins
Thanks for all that responded. It appears that the answer is no.
Original question:
The oracle DBA's recently asked me if it makes a difference that the file system
is set for 4KB page size and the memory for 8KB. Are you wasting 4 KB per page?
Here are some answers
From: alan_at_nabeth.cxo.dec.com
Neither AdvFS nor UFS supports setting the file system
block size to 4 KB on Tru64 UNIX. UFS should be able
to handle ULTRIX file systems with a 4 KB block size
though. If Oracle supports using a different internal
block size than whatever file system it is sitting on
top of, then you just added a question: "What is the
affect of making the Oracle block size different from
the underlying file system block size"?
From: dgreed_at_bpa.gov
You aren't wasting memory, however, if this is a system which handles
queries rather than OLTP loads, the page size that small will result in many
more OS reads than necessary. I'd raise it in any case to 8KB.
There were several others along the same lines.
Thanks to all
Lee Brewer
Received on Tue Apr 24 2001 - 13:29:52 NZST