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@xxxxxxxxxxxxxxxx> 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@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 > > > > -- > //www.freelists.org/webpage/oracle-l > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l