Re: Slow UPDATE

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Sun, 16 May 2004 17:26:20 +0200
Message-ID: <011601c43b5a$24e77320$3c02a8c0@JARAWIN>

Hi Thomas,

• Original Message ----- From: "Thomas Jeff" <jeff.thomas_at_thomson.net> To: <oracle-l_at_freelists.org> Sent: Friday, May 14, 2004 3:18 PM Subject: Slow UPDATE

if the table 'OD_CUST_LOCS' has approximately 9682 blocks (=1936484/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 = :66 AND KEY_ID = :67 AND SOURCE_ID = :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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sun May 16 2004 - 10:24:21 CDT