1. For more details about how to tune ASYNC I/O for Raw disk partitions on HP_UX kindly refer,
Oracle Database Administrator's Reference
11g Release 1 (11.1) for Linux and UNIX-Based Operating Systems
Part Number B32009-05
Appendix B 'Administering Oracle Database on HP-UX'
section 'Asynchronous Input-Output'
For Oracle 10G,
http://download.oracle.com/docs/cd/B19306_01/server.102/b15658/appb_hpux.htm#i637036
For Oracle 11G,
http://download.oracle.com/docs/cd/B28359_01/server.111/b32009/appb_hpux.htm#i637036
2. For File system to improve the performance,
Set disk_asynch_io = FALSE and increase the DB writer process.
Based upon the number of CPUs and the number of processor groups, Oracle either selects an
appropriate default setting for DB_WRITER_PROCESSES or adjusts a user-specified setting.
Example for 4 CPU machine,
SQL>alter system set db_writer_processes = 4 scope = spfile ;
Sometime the false Warning message will be displayed in alert log eventhough the DISK_AYNC_IO is set to FALSE.
Inorder to stop this Warning message we have to apply this Patch 8475825 which is available for most of the OS.
Reference Bug 8475825 - OS ASYNC I/O LIMIT 128 IS LOWER THAN RECOVERY BATCH 1024
3.On Redhat Linux 4 and 5 the recommended action is to raise the value of /proc/sys/fs/aio-max-nr.
eg: Set the value to 1048576 or higher.
============================
To set the value forSUSE linux:
In the file /etc/sysctl.conf , add the below entry:
fs.aio-max-nr=1048576
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11134237/viewspace-684454/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11134237/viewspace-684454/