RE: Slow UPDATE

  • From: "Thomas Jeff" <jeff.thomas@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 17 May 2004 07:42:58 -0500

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
-----------------------------------------------------------------

Other related posts: