My System is running an OLTP application and oracle database.
For Oracle database:
As we know, the ZFS record size have to set to 8KB for the data file system to optimize the performance (and other undo, redo, archive...not to mention here since not important to my question)
But what about the OLTP Application?
I remember there have an oracle white paper (Saw it once on the internet, but cant find the link now), this white paper say that Oracle strongly not recommended to modify the record size of a normal file system (non-oracle data File file system). it should always keep as default (128)
However, my team mate is saying the application file system should modify the record size to 8 also, the reason is, this is an OLTP application.
So does anyone know is there any document support?
Mange to find the link, so sorry is not a white paper but is "Solaris ZFS administration guide"
The "General propose" key words, can it refer to OLTP application file system?
Please review this section of the docs, here:
The current recommendation is to match the ZFS file system recordsize to the OLTP applicaton block or recordsize.