DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding;
        b=gvCJtxa9/cSRfXK3Brpw6WW9+mjDuOOFHNkCA6KRtftzduBbwqjqlgwXc4JR1CwYrvIVNJ/WdC2usa2PP6ihdOz93CTOatvfHCuhNQ2wT1Xpn2MOqnsoAnjKm7FPy8HimSwf/wnrv41e+UM3qp2TL12YCoAN37JblimUb3SBZFs=
Message-ID: <4751A477.7000208@gmail.com>
Date: Sat, 01 Dec 2007 10:14:15 -0800
From: Bob Carlin <smeghead.rimmer@gmail.com>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
To: oraclev28@gmail.com
CC: "oracle-l@freelists.org" <oracle-l@freelists.org>, ajeet.ojha@ge.com
Subject: Re: why the cardinality of explain plan defers with the caridnality
 in row source operation
References: <4303736f0711270615re44fe55x9878a1626713574e@mail.gmail.com>
In-Reply-To: <4303736f0711270615re44fe55x9878a1626713574e@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: smeghead.rimmer@gmail.com

Ajeet,
I would suggest looking at some tips at

http://structureddata.org/2007/11/21/troubleshooting-bad-execution-plans/

ajeet ojha wrote:
> Hello,
>  
> In my database environment for many of the queires the explain plan 
> cardinality defers (huge difference) with the cardinality shown by row 
> source operations of tkprof.
> I have been trying to find all possible reasons -
>  
> so far I came to know that 2 main reasons -
>  
> 1. limitation of cbo as mentioned in the link below
>  
> http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:40230704959128
>  
> it also tells that solution is such cases is use dynamic_samping.
>  
> 2. the other reason is poor stats on the undelying tables/indexes.
>  
> please add if there are any more.
>  
> also how to collect a good stats  - is there any oracle recommendation 
> - best practices ?
>  
> are the above 2 are only reasons or there are many more - i went to 
> differnt forums and it seems that there are many more.
> please share if you have come across such sitution - possible 
> solutions etc.
>  
> Thanks
> Ajeet

--
http://www.freelists.org/webpage/oracle-l