DB_BLOCK_SIZE and Digital UNIX with AdvFS

Hi!

I'm not a DBA, so go easy on me! ;-) One of the tuning tips I've run across indicates that it is best to make DB_BLOCK_SIZE at least as large as the file system buffer size, if not a larger multiple of it. It's my understanding that AdvFS uses 8 KB "pages" which would seem to indicate that I should use at least an 8 KB DB_BLOCK_SIZE. Is this reasonable for a small-medium sized dB, and what might be the ramifications of using a block size this large? I understand that I'll have to correspondingly reduce DB_BLOCK_BUFFERS to reduce the size of the SGA to avoid memory problems. How much inefficiency is introduced by using a smaller DB_BLOCK_SIZE? Or can one do this at all?

I realize I'm not providing a lot of detail (the application is OGF, if that helps a bit), so I don't expect a fully detailed response, but if there are others of you using AdvFS, I'd be interested in hearing how you approached this.

TIA,
Robert Received on Mon May 12 1997 - 00:00:00 CDT