Re: SQL tuning...

Venu,

Do your 10046 tracing and run it through tkprof of the Hotsos Profiler and you'll know exactly why your query is taking so long.

Regards,
Gudmundur

> Can anyone tell me whats wrong
> with the explain plan below… this update is running for quite long time….
> Even without a single full-table access…
>
>  
>
> Thank you in advance!
>
>  
>
>  
>
> UPDATE STATEMENT Optimizer=CHOOSE (Cost=83
> Card=4893 Bytes=327831)
> UPDATE OF CCM_DEBIT_TBL
> SEQUENCE OF STAFFWARE_CASEID_S
> FILTER
> TABLE ACCESS (BY GLOBAL INDEX ROWID) OF CCM_DEBIT_TBL (Cost=83 Card=4893
> Bytes=327831)
> INDEX (RANGE SCAN) OF IDX_DEBIT_DUE_DATE (NON-UNIQUE) (Cost=26 Card=4893)
> INDEX (RANGE SCAN) OF IDX_PLAN_DEBIT_CISDEBITDEAD (NON-UNIQUE) (Cost=3 Card=1
> Bytes=26)
> INDEX (RANGE SCAN) OF IDX_PLAN_DEBIT_CISDEBITDEAD (NON-UNIQUE) (Cost=3 Card=1
> Bytes=28)
> TABLE ACCESS (BY GLOBAL INDEX ROWID) OF CCM_ACCOUNT_TBL (Cost=1 Card=1 Bytes=9)
> INDEX (UNIQUE SCAN) OF PK_ACCOUNT (UNIQUE) (Cost=2 Card=1)
>
>
>
>
>
>
> Confidentiality Notice
>
> The information contained in this electronic message and any attachments to this message are intended
> for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
> you are not the intended recipient, please notify the sender at Wipro or Mailadmin_at_wipro.com immediately
> and destroy all copies of this message and any attachments.

Þessi póstur var sendur með vefpósti mi, http://www.mi.is

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gudmundur Josepsson
  INET: gbj_at_index.is

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).