RE: parse

What version of Oracle?

Have you checked V$SQL_SHARED_CURSOR for that statement?

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of David
Sent: Monday, October 04, 2004 1:54 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: parse


I have a db where exec to parse ratio is bad.  One update is parsing for
each execute.  Any thoughts on why?

Thanks!
David

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:  100.00       Redo NoWait %:  100.00
            Buffer  Hit   %:   99.01    In-memory Sort %:  100.00
            Library Hit   %:  100.00        Soft Parse %:  100.00
         Execute to Parse %:   23.57         Latch Hit %:   99.99
Parse CPU to Parse Elapsd %:   94.49     % Non-Parse CPU:   99.08

SQL Statistics

~~~~~~~~~~~~~~

-> CPU and Elapsed Time are in seconds (s) for Statement Total and in

   milliseconds (ms) for Per Execute

                                                       % Snap

                     Statement Total      Per Execute   Total

                     ---------------  ---------------  ------

        Buffer Gets:         175,942             11.8     .91

         Disk Reads:           6,605              0.4    3.44

     Rows processed:          17,210              1.2

     CPU Time(s/ms):               5               .3

 Elapsed Time(s/ms):              73              4.9

              Sorts:               0               .0

        Parse Calls:          14,953              1.0

      Invalidations:               0

      Version count:               5

    Sharable Mem(K):              19

         Executions:          14,953



SQL Text

~~~~~~~~

update equipment_table set deleted =3D 1 where item_id =3D :item_id

--=20

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: