It's a frustration question! The query has been hard parsed once and soft parsed 26 times since Aug 16th - instance start. On the plus side our cache hit ratio is pretty good now. SQL>@BCHR BCHR ---------- 99.4119614 :) On Nov 30, 2007 1:20 PM, <torben.holm@xxxxxxxxxxxx> wrote: > Is this a trick question? :-) > Anyway what do you know about number of parses? > > /torben > -----Oprindelig meddelelse----- > From: "Niall Litchfield" niall.litchfield@xxxxxxxxx > Date: Fri, 30 Nov 2007 14:07:42 +0100 > To: "Members Oak Table" list42@xxxxxxxxxxxx > Subject: why is the <system name> going slow Niall? > > > Say the end-users. Is there just perhaps the tiniest chance, I ask the > > vendors, if these statistics for a single sqlstatement have something to > do > > with it, perchance - what you can't see is that the executions figure > has > > wrapped several times since instance start - we are currently executing > this > > statement 2000 times a second. No say said vendors when we see this > *it's > > because the application log file is too large*. The query being > essentially > > what application identifier is associated with the currently running > module. > > > > > > SELECT ACM_ARC_SYS_CODE FROM AREA_CODE_MODULES WHERE ACM_MOD_NAME = :1 > > > > Execution Statistics > > Total Per Execution Per Row Executions 208,643,586 1 1.00 CPU Time (sec) > > 246,334.52 0.00 0.00 Buffer Gets 626,241,177 3.00 3.00 Disk Reads 683 > 0.00 > > 0.00 Direct Writes 0 0.00 0.00 Rows 208,473,237 1.00 1 Fetches > 208,643,555 > > 1.00 1.00 > > -- > > Niall Litchfield > > Oracle DBA > > http://www.orawin.info > > > > > > Mvh > Torben Holm > +45 25277104 > Miracle A/S > torben.holm@xxxxxxxxxxxx > http://www.MiracleAS.dk <http://www.miracleas.dk/> > > > -- Niall Litchfield Oracle DBA http://www.orawin.info