Low Parse CPU to Parse Elapsd %: 16.70 With High cpu
Hello All
My Application does not use bind variables , but all the efficiency percentages are high except Parse CPU to Parse Elapsd %: 16.70 . The cpu is 100% utilized with run queue greater than nos of processors ,will using bind variables reduce cpu .db is 11.2.0.2
Instance Efficiency Indicators
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.69 Optimal W/A Exec %: 99.89
Library Hit %: 96.50 Soft Parse %: 88.56
Execute to Parse %: 90.72 Latch Hit %: 99.85
Parse CPU to Parse Elapsd %: 16.70 % Non-Parse CPU: 99.05
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 32.87 32.63
% SQL with executions>1: 92.09 84.77
% Memory for SQL w/exec>1: 89.57 85.39
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time