Re: Slow UPDATE
- From: "Terry Sutton" <terrysutton@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 16 May 2004 19:29:03 -0700
Look at the trace itself (not the tkprof), see what the query is actually
doing. If the query is using the index, you'll see "db file sequential
reads" of the index and table. If it's doing table scans you'll see "db
file scattered reads".
--Terry
----- Original Message -----
You're saying that a 10046 trace isn't always reliable with respect to
identifying
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 -----
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 (=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@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:
