Never mind, did some RTFMing, and yes, using the EXPLAIN=3D option will not always=20 result in the correct plan that was actually used. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thomas Jeff Sent: Sunday, May 16, 2004 8:38 PM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: Slow UPDATE Thanks for the reply Jaromir. =20 You're saying that a 10046 trace isn't always reliable with respect to identifying=20 the 'real' execution plan? -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of jaromir nemec Sent: Sunday, May 16, 2004 10:26 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Slow UPDATE Hi Thomas, ----- Original Message -----=20 From: "Thomas Jeff" <jeff.thomas@xxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Friday, May 14, 2004 3:18 PM Subject: Slow UPDATE if the table 'OD_CUST_LOCS' has approximately 9682 blocks = (=3D1936484/200) I'm pretty sure that the update is doing full scan on it. If you are on 9i check the "real" execution plan in V$SQL_PLAN. >call count cpu elapsed disk query current rows > Execute 200 578.44 789.45 1852160 1936484 218 200 An "elegant" explanation will be that the Informatica ports have different types than the PK columns. Check the type of the ports 66-68 > WHERE SRC_EFF_FROM_DT =3D :66 AND KEY_ID =3D :67 AND SOURCE_ID =3D :68 regards Jaromir D.B. Nemec http://www.db-nemec.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------