Oracle Database Discussions

Hi DBAs,

I took the AWR for 1 hour load testing period and observed the very low Execute to Parse % and Parse CPU to Parse Elapsd %. I putting some segment of AWR , if you can help me to diagnose any issue. This is stand alone 11gR1 instance on RHEL 5.3.

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 99.10 Soft Parse %: 99.83
Execute to Parse %: 4.05 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 0.00 % Non-Parse CPU: 95.11

Top 5 Timed Foreground Events


Event Waits Time(s) Avg wait (ms) % DB time Wait Class
log file sync 11,322 567 50 75.71 Commit
DB CPU 70 9.29
db file sequential read 1,384 41 30 5.51 User I/O
enq: TX - row lock contention 2,383 19 8 2.56 Application
db file scattered read 308 4 14 0.58 User I/O

Time Model Statistics
Total time in database user-calls (DB Time): 748.3s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name
Statistic Name Time (s) % of DB Time
sql execute elapsed time 174.38 23.30
DB CPU 69.56 9.29
Java execution elapsed time 21.75 2.91
parse time elapsed 15.29 2.04
hard parse elapsed time 11.52 1.54
connection management call elapsed time 8.32 1.11
PL/SQL compilation elapsed time 1.66 0.22
PL/SQL execution elapsed time 1.46 0.19
failed parse elapsed time 0.05 0.01
hard parse (sharing criteria) elapsed time 0.02 0.00
repeated bind elapsed time 0.01 0.00
sequence load elapsed time 0.00 0.00
DB time 748.32
background elapsed time 489.23
background cpu time 3.80


---------


Please let me know if you have any recommendations/suggestion

Thanks
-Samar-