oracle10g m000,Oracle10g RAC DB CPU 100% Analysis and Summary

[oracle@pxydb01 bdump]$ more pxyex1_m000_162942.trc

/oracle/admin/pxyex/bdump/pxyex1_m000_162942.trc

Oracle Database 10g Enterprise Edition Release

10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters,

OLAP, Data Mining

and Real Application Testing options

ORACLE_HOME =

/oracle/product/10.2.0/db_1

System

name: Linux

Node

name: pxydb01

Release: 2.6.32-279.el6.x86_64

Version: #1 SMP Wed Jun 13 18:24:36 EDT 2012

Machine: x86_64

Instance name: pxyex1

Redo thread mounted by this instance: 1

Oracle process number: 166

Unix process pid: 162942, image: oracle@pxydb01

(m000)

*** ACTION NAME:(Auto-Flush Slave Action)

2016-09-24 09:00:03.151

*** MODULE NAME:(MMON_SLAVE) 2016-09-24

09:00:03.151

*** SERVICE NAME:(SYS$BACKGROUND) 2016-09-24

09:00:03.151

*** SESSION ID:(3525.706) 2016-09-24

09:00:03.151

WARNING:io_submit failed due to kernel limitations

MAXAIO for process=0 pending aio=0

WARNING:asynch I/O kernel limits is set at

AIO-MAX-NR=65536 AIO-NR=65461

WARNING:1 Oracle process running out of OS

kernelI/O resources aiolimit=0

ksfdgo()+1488

()+1286

unhandled instruct

ion at 0x1f01b4f instr=f

oodr()+554

unhandled instruction at 0x150d2ff instr=6a

ssd_unwind_bp: unhandled instruction at 0x150ba53

instr=68

xecute_wr_sql()+52

ehdlcx()+805

-_start()+41

[oracle@pxydb01 bdump]$