程式日誌中出現out of OS kernel IO resources

錯誤資訊如下：

/ora10g/app/admin/dbname/bdump/dbname1_j001_8567.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /ora10g/app/product/10.2.0/dbname
System name: HP-UX
Node name: dbname1
Release: B.11.23
Version: U
Machine: ia64
Instance name: dbname1
Redo thread mounted by this instance: 1
Oracle process number: 34
Unix process pid: 8567, image: oracle@dbname1 (J001)

*** 2011-11-14 22:40:19.204
*** ACTION NAME:(GATHER_STATS_JOB) 2011-11-14 22:40:19.066
*** MODULE NAME:(DBMS_SCHEDULER) 2011-11-14 22:40:19.066
*** SERVICE NAME:(SYS$USERS) 2011-11-14 22:40:19.066
*** CLIENT ID:() 2011-11-14 22:40:19.066
*** SESSION ID:(1476.50721) 2011-11-14 22:40:19.066
WARNING:Oracle process running out of OS kernel I/O resources
*** 2011-11-14 22:40:55.057
WARNING:Oracle process running out of OS kernel I/O resources
*** 2011-11-14 22:44:30.269
WARNING:Oracle process running out of OS kernel I/O resources
*** 2011-11-14 22:47:40.952
WARNING:Oracle process running out of OS kernel I/O resources
WARNING:Oracle process running out of OS kernel I/O resources

檢查了一下MOS，發現了相似的bug：

Bug 6687381 - "WARNING: Oracle process running out of OS kernel I/O resources" messages [ID 6687381.8]；

Bug 6908655 - "WARNING:Oracle process running out of OS kernel I/O resources" messages [ID 6908655.8]；

Bug 7523755 - "WARNING:Oracle process running out of OS kernel I/O resources" messages [ID 7523755.8]

這幾個bug的共同點是都影響10.2.0.5一下的版本，且問題都在10.2.0.5被fixed。在11g的版本中，這幾個bug的表現有所差別，第一個bug在11.1.0.7中被fixed，而另外兩個需要在11.2.0.1中才被fixed。

這個問題可能導致嚴重的效能影響，嚴重的情況下甚至是資料庫的崩潰，因此如果告警日誌或trace檔案中頻繁出現這個問題，建議儘快按照補丁解決這個問題。