| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: why is the <system name> going slow Niall?
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
:)
On Nov 30, 2007 1:20 PM, <torben.holm_at_miracleas.dk> wrote:
> Is this a trick question? :-)
> Anyway what do you know about number of parses?
>
> /torben
> -----Oprindelig meddelelse-----
> From: "Niall Litchfield" niall.litchfield_at_gmail.com
> Date: Fri, 30 Nov 2007 14:07:42 +0100
> To: "Members Oak Table" list42_at_oaktable.net
> 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_at_miracleas.dk
> http://www.MiracleAS.dk <http://www.miracleas.dk/>
>
>
>
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 30 2007 - 08:17:53 CST
 |
 |