Question:
I am seeing this ORA-27090 message in my
Linux alert log at system startup time:
ORA-27090: Message 27090 not found;
product=RDBMS; facility=ORA
ORA-27090: UNABLE TO RESERVE KERNEL
RESOURCES FOR ASYNCHRONOUS DISK I/O
ORA-27090: Message 27090 not
found; product=RDBMS; facility=ORA Linux-x86_64 Error: 4:
Interrupted system call
How do I fix this ORA-27090 error?
Answer:
The
oerr utility show this detail for the ORA-27090 error,
indicating that a ORA-27090 error is caused by an OS kernel
parameter limitation causing a lack of system resources.
ORA-27090: Unable to reserve kernel resources
for asynchronous disk I/O
Cause: The system call to
reserve kernel resources for asynchronous I/O has failed.
Action: Check errno
In Linux, this error can appear when the
/sbin/sysctl parameter "aio-max-nr" kernel limit is set too low.
You can cease the ORA-27090 error by increasing the "aio-max-nr"
kernel limit as per the Oracle recommendation:
fs.aio-max-nr= 3145728
MOSC note 748607.1
has complete details on the ORA-27090 error, and Oracle > claims
that the ORA-27090 error will not appear in release 11.2 and beyond.
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
