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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l