Ours is Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Db 4 instances RAC on Unix AIX OS.
Since long we are facing problem that CPU utilization reached 100% and reboot is required alteast once or twice a month.
On seeing the Events Logs we find that the Event "CURSOR PIN S WAIT FOR X" is consuming a lot of waits.
On analyzing i came to know that we are firing same query from Application 15 to 20 lack times for which a lot of Mutex keeps spining for getting Shared Mode and consumes a large amount of CPU.
Problem here is in AIX we dont have HPUP_SCHED_NOAGE param.
Please help me out what should i do.