Instance Efficiency Percentages Issue
From our AWR report, I am seeing there is some issue with Instance efficiency percentages.
1. Execute to Parse is always < 65%
2. Parse CPU to Parse Elapsd is always 0.
Is there any way i can accelerate above parameters to 90% (OR) leaving this parameters will hamper anything to the database?
RAC INSTANCE 1:
WORKLOAD REPOSITORY report for
DB Name DB Id Instance Inst Num Startup Time Release RAC
------------ ----------- ------------ -------- --------------- ----------- ---
abc 1752707386 abc1 1 02-Sep-11 03:31 11.1.0.7.0 YES
Host Name Platform CPUs Cores Sockets Memory(GB)
---------------- -------------------------------- ---- ----- ------- ----------
aaa AIX-Based Systems (64-bit) 4 2 64.00
Snap Id Snap Time Sessions Curs/Sess