tkprof output help

From: <thump604_at_comcast.net>
Date: Wed, 28 Apr 2004 20:40:48 +0000
Message-Id: <042820042040.3474.409016CF000CF95C00000D922200761438FFCBCFC98F928A97@comcast.net>

db is 8174 in rbo mode.

There is 1 row in the S_PARTY_PER_DTL_X table that would have a specific PAR_ROW_ID so why would it take 247 row fetches and 247 rows processed?

SELECT

      T1.LAST_UPD,
      T1.CREATED_BY,
      T1.CONFLICT_ID,
      T1.CREATED,
      T1.NUMBER_OF_TERMS,
      T1.ROW_ID,
      T1.RELATIONSHIP_END_DT,
      T1.RELATIONSHIP_START_DT,
      T1.DISCIPLINE,
      T1.PROMO_CODE,
      T1.MODIFICATION_NUM,
      T1.RELATIONSHIP_STATUS,
      T1.RELATION_TYPE_CD,
      T1.LAST_UPD_BY
   FROM 
       SIEBEL.CX_S_PARTY_PER_DTL_X T1
   WHERE
      (T1.PAR_ROW_ID = :1)

call     count       cpu    elapsed       disk      query    current        rows


------- ------  -------- ---------- ---------- ---------- ----------  ----------

Parse        1      0.00       0.00          0          0          0           0
Execute    247      0.02       0.01          0          0          0           0
Fetch      247      0.01       0.01          0        998          0         247


------- ------  -------- ---------- ---------- ---------- ----------  ----------

total      495      0.03       0.02          0        998          0         247

Misses in library cache during parse: 0
Optimizer goal: RULE
Parsing user id: 66 (CRAIGC)

Rows Execution Plan
------- ---------------------------------------------------

      0  SELECT STATEMENT   GOAL: RULE
      0   TABLE ACCESS (BY INDEX ROWID) OF 'CX_S_PARTY_PER_DTL_X'
      0    INDEX (RANGE SCAN) OF 'CX_S_PARTY_PER_DTL_X_U1' (UNIQUE)

SQL> select count(*) from siebel.cx_s_party_per_dtl_x;

  COUNT(*)

---

    780454

Thanks for any insight!
--

- David Green

---

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 Wed Apr 28 2004 - 15:37:50 CDT