Parsing Problem - I think
From: Fred Tilly <ftilly_at_btinternet.com>
Date: Tue, 25 Mar 2014 12:29:38 +0000 (GMT)
Message-ID: <1395750578.78657.YahooMailNeo_at_web87802.mail.ir2.yahoo.com>
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.6 0.5 Hard parses: 5.1 0.1 Elapsed: 59.37 (mins) DB Time: 587.12 (mins) Buffer Nowait %: 100.00 Redo NoWait %: 100.00 Buffer Hit %: 99.91 In-memory Sort %: 100.00 Library Hit %: 94.89 Soft Parse %: 77.60 Execute to Parse %: 92.71 Latch Hit %: 99.95 Parse CPU to Parse Elapsd %: 57.49 % Non-Parse CPU: 54.03 Top 5 Timed Foreground Events Event Waits Time(s) Avg wait (ms) % DB time Wait Class DB CPU 22,086 62.70 cursor: pin S wait on X 12 705 58760 2.00 Concurrency log file sync 142,183 469 3 1.33 Commit db file sequential read 48,259 155 3 0.44 User I/O buffer busy waits 2,144 129 60 0.37 Concurrency Statistic Name Time (s) % of DB Time DB CPU 22,086.13 62.70 parse time elapsed 19,559.05 55.52 hard parse elapsed time 18,490.89 52.49 sql execute elapsed time 15,126.32 42.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
Date: Tue, 25 Mar 2014 12:29:38 +0000 (GMT)
Message-ID: <1395750578.78657.YahooMailNeo_at_web87802.mail.ir2.yahoo.com>
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.6 0.5 Hard parses: 5.1 0.1 Elapsed: 59.37 (mins) DB Time: 587.12 (mins) Buffer Nowait %: 100.00 Redo NoWait %: 100.00 Buffer Hit %: 99.91 In-memory Sort %: 100.00 Library Hit %: 94.89 Soft Parse %: 77.60 Execute to Parse %: 92.71 Latch Hit %: 99.95 Parse CPU to Parse Elapsd %: 57.49 % Non-Parse CPU: 54.03 Top 5 Timed Foreground Events Event Waits Time(s) Avg wait (ms) % DB time Wait Class DB CPU 22,086 62.70 cursor: pin S wait on X 12 705 58760 2.00 Concurrency log file sync 142,183 469 3 1.33 Commit db file sequential read 48,259 155 3 0.44 User I/O buffer busy waits 2,144 129 60 0.37 Concurrency Statistic Name Time (s) % of DB Time DB CPU 22,086.13 62.70 parse time elapsed 19,559.05 55.52 hard parse elapsed time 18,490.89 52.49 sql execute elapsed time 15,126.32 42.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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 25 2014 - 13:29:38 CET