Re: Parsing Problem - I think
- From: Milo <xueyuan.luo@xxxxxxxxx>
- To: ftilly <ftilly@xxxxxxxxxxxxxx>
- Date: Tue, 25 Mar 2014 20:40:49 +0800
Hi, Fred
In my opinion, you should really check the hard parse issue in your db.
The soft parse percentage and hard pase time take up most of parse time.
And the most possible reason for wait event 'cursor: pin S wait on X' might
really cause by this.
Best Regards,
Milo
From: Fred Tilly
Date: 2014-03-25 20:29
To: oracle-l@xxxxxxxxxxxxx
Subject: Parsing Problem - I think
Hi All,
Looking at an AWR report from a customer site where they have had some very
slow performance.
Server is 32 CPU and 26GB running Oracle 11.2.0.3
AWR is over 1 hour and shows:
Parses:22.60.5
Hard parses:5.10.1
Elapsed: 59.37 (mins)
DB Time: 587.12 (mins)
Buffer Nowait %:100.00Redo NoWait %:100.00
Buffer Hit %:99.91In-memory Sort %:100.00
Library Hit %:94.89Soft Parse %:77.60
Execute to Parse %:92.71Latch Hit %:99.95
Parse CPU to Parse Elapsd %:57.49% Non-Parse CPU:54.03
Top 5 Timed Foreground Events
EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 22,086 62.70
cursor: pin S wait on X12705587602.00Concurrency
log file sync142,18346931.33Commit
db file sequential read48,25915530.44User I/O
buffer busy waits2,144129600.37Concurrency
Statistic NameTime (s)% of DB Time
DB CPU22,086.1362.70
parse time elapsed19,559.0555.52
hard parse elapsed time18,490.8952.49
sql execute elapsed time15,126.3242.94
From the information in the AWR report I do not appear to be parsing a lot of
statements per second, but my hard parse time seems really high.
What else do I need to look at to get to the bottom of this issue.
Thanks
Fred
Other related posts:
