Re: parse

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 4 Oct 2004 12:00:27 -0700
Message-ID: <bf463804100412004de73a2d@mail.gmail.com>

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 - 13:55:56 CDT