Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: parse
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'
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-lReceived on Mon Oct 04 2004 - 13:55:56 CDT
![]() |
![]() |