Re: parse

On Mon, 4 Oct 2004 10:53:54 -0700 (PDT), David <thump@xxxxxxxxxxxxxxxx> 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

Other related posts: