Solution : https://service.sap.com/sap/support/notes/999524 (SAP Service marketplace login required)
Summary :
This SAP Note addresses issues related to poor IO performance, long read and write times in single-instance databases (not RAC). It recommends utilizing Async IO, Direct IO, and Concurrent IO simultaneously to maximize database IO efficiency. Best practices include setting `FILESYSTEMIO_OPTIONS = SETALL` in the `init.ora` or `spfile` to activate these IO optimizations. Platform-specific capabilities and configuration requirements for Async, Direct, and Concurrent IO are listed, ensuring that the database, log, and control file systems are properly configured. This includes specific instructions for different operating systems and filesystems.
Key words :
- rhel4 update 3 + bugzilla fix 161362 - rhel4 update 4 - sles9 sp3, platform / filesystem async io direct io concurrent ioraw, additional platform specific required mount options, install hp sg sms ii, execution async io requests obsolete, hp serviceguard storage management suite, filesystem mount options mincache=direct, /sbin/mknod /dev/async, noibm aix 5l jfs2, yesibm aix 5l gpfs
Related Notes :
| 1266874 | Support for SAP software in Linux / Symantec environments |
| 1114181 | Oracle DB, SLES and RHEL Linux, file system and I/O type |
| 1077887 | SAP on HP-UX:mount & filesystem options for best performance |
| 948294 | AIX JFS2: mount options to use with Oracle 10g / 11g |
| 936441 | Oracle settings for R3load based system copy |
| 830576 | Parameter recommendations for Oracle 10g |
| 793113 | FAQ: Oracle I/O configuration |
| 534036 | SAP LT: System settings for conversions |
| 405827 | Journaled file system and raw devices on Linux |