Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL tuning...

Re: SQL tuning...

From: Gudmundur Josepsson <gbj_at_index.is>
Date: Thu, 18 Dec 2003 03:09:25 -0800
Message-ID: <F001.005DA4FC.20031218030925@fatcity.com>


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&#8230; this update is running for quite long time&#8230;.
> Even without a single full-table access&#8230;
>
> &nbsp;
>
> Thank you in advance!
>
> &nbsp;
>
> &nbsp;
>
> 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).
Received on Thu Dec 18 2003 - 05:09:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US