Re: parse
- From: Jared Still <jkstill@xxxxxxxxx>
- To: thump@xxxxxxxxxxxxxxxx
- Date: Mon, 4 Oct 2004 12:00:27 -0700
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
Other related posts:
