Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exotic Blocksize 6144 Byte
Mark D Powell wrote:
> If the OS block size is 4K the two OS IO are required for every Oracle
> IO and 25% of the IO is wasted since it is not part of the requested
> Oralce block(s). This would be bad. If on the other hand the OS IO
> size is 6k then the 6k size choice for Oracle was probably a good one
> in the past. Since the manuals refer to Oracle only officially
> supporting 4k, 8k, 16k, and 32k you may want to determine what the real
> OS IO size is and match the database to it.
Probably you are referring to the virtual memory pagesize, which is 4K on windows.
However it is not really an issue since windows doesn't allow buffered i/o but only direct i/o.
This is why I stated that ntfs has similarity with raw devices.
I have never seen a block size different from the ones you listed (plus 2k) but I don't see why it cannot be used (never asserted anything about performance).
Regards
-- Fabrizio Magni fabrizio.magni_at_mycontinent.com replace mycontinent with europeReceived on Sun Apr 03 2005 - 13:03:51 CDT