Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: parse

Re: parse

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 4 Oct 2004 13:05:53 -0700
Message-ID: <bf4638041004130552c0f563@mail.gmail.com>


Kind of interesting that your parse misses (failures) is 8 time higher than total parse count.

You may want to investigate that.

Jared

On Mon, 4 Oct 2004 12:11:25 -0700 (PDT), David <thump_at_cosmiccooler.org> wrote:
> version 9205
>
> CLASS_NAME
> ---------------
> NAME VALUE
> ---------------------------------------------------------------- ----------
> SQL
> parse count (failures) 870249566
> SQL
> parse count (hard) 2699779
> SQL
> parse count (total) 117112761
> SQL
> parse time cpu 370623
> SQL
> parse time elapsed 402442
> --
> ..
> David
>
>
>
> > On Mon, 4 Oct 2004 10:53:54 -0700 (PDT), David <thump_at_cosmiccooler.org>
> > wrote:
> >> I have a db where exec to parse ratio is bad. One update is parsing for
> >> each execute. Any thoughts on why?
> >>
> >
> > Could be soft parses.
> >
> > What version of Oracle?
> >
> > This will show instance wide parses:
> >
> > select
> > decode(class,
> > 1,'User',
> > 2,'Redo',
> > 4,'Enqueue',
> > 8,'Cache',
> > 16,'OS',
> > 32,'Parallel Server',
> > 64,'SQL',
> > 128,'Debug'
> > ) class_name
> > ,name
> > ,value
> > from v$sysstat
> > where upper(name) like '%PARSE%'
> > order by class_name, name
> >
> > Take a look at hard parses vs parse total.
> >
> >
> >
> > --
> > Jared Still
> > Certifiable Oracle DBA and Part Time Perl Evangelist
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 04 2004 - 15:01:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US