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
Received on Mon Oct 04 2004 - 14:07:02 CDT
