DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws;  s=s1024; d=yahoo.com;  h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;  b=h0mdmPGlI/IXxLC+S+dLQQ7JMd8lM/MWSDqBvPf/uM0py5Cxgjirl96CMxlKScQ1hlJCyxrXmF9JeCLOFNXMGMU105zCZ/sTAEsnSKNVBBoY3IwLk3tBanYkeCyOppoF+XO6ZZfXsd5cBvlEGL1vV3zSypoWpJ6B/VrGvAvmv1Y=;
Message-ID: <529356.62189.qm@web120211.mail.ne1.yahoo.com>
References: <AANLkTi=dGH7WraigWxu8y7GkA+r=Hu8x4jWuKfRo1fm3@mail.gmail.com>
Date: Wed, 10 Nov 2010 22:10:05 -0800 (PST)
From: Kellyn Pedersen <kjped1313@yahoo.com>
Subject: Re: Dynamic sampling
To: hemantkchitale@gmail.com, ORACLE-L <oracle-l@freelists.org>
In-Reply-To: <AANLkTi=dGH7WraigWxu8y7GkA+r=Hu8x4jWuKfRo1fm3@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-182500033-1289455805=:62189"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: kjped1313@yahoo.com
--0-182500033-1289455805=:62189
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

=0A=0ADynamically generate SQL on the list of tables involved=A0for =0Adbms=
_stats.lock_table_stats and execute... :P=0ADon't worry, you don't have to=
=A0thank me...:)=0A=A0=0AKellyn Pedersen=0ASr. Database Administrator=0Ahtt=
p://www.linkedin.com/in/kellynpedersen=0Awww.dbakevlar.com=0A=A0=0A=0A=0A=
=0A=0A________________________________=0AFrom: Hemant K Chitale <hemantkchi=
tale@gmail.com>=0ATo: ORACLE-L <oracle-l@freelists.org>=0ASent: Wed, Novemb=
er 10, 2010 8:43:09 PM=0ASubject: Dynamic sampling=0A=0A=0AAARGH! =0AWhat y=
ou do when DBMS_XPLAN.DISPLAY_CURSOR shows a 190 line Plan with 205 =0Aentr=
ies in the Predicates section=A0 and then adds "dynamic sampling used".=0AJ=
ust venting my frustration.=0A=0AHemant K Chitale=0Ahttp://hemantoracledba.=
blogspot.com=0Asent from my smartphone=0A=0A=0A      
--0-182500033-1289455805=:62189
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:times new roman, new york, times, serif;=
font-size:12pt"><DIV></DIV>=0A<DIV><BR>=0A<DIV>Dynamically generate SQL on =
the list of tables involved&nbsp;for dbms_stats.lock_table_stats and execut=
e... :P</DIV>=0A<DIV>Don't worry, you don't have to&nbsp;thank me...:)<BR>&=
nbsp;</DIV></DIV>=0A<P>Kellyn Pedersen</P>=0A<P>Sr. Database Administrator<=
/P>=0A<P><A title=3D"View public profile" href=3D"http://www.linkedin.com/i=
n/kellynpedersen" name=3DwebProfileURL rel=3Dnofollow target=3D_blank>http:=
//www.linkedin.com/in/kellynpedersen</A></P>=0A<P><A href=3D"http://www.dba=
kevlar.blogspot.com/" rel=3Dnofollow target=3D_blank>www.dbakevlar.com</A><=
/P>=0A<P>&nbsp;</P>=0A<DIV><BR></DIV>=0A<DIV style=3D"FONT-FAMILY: times ne=
w roman, new york, times, serif; FONT-SIZE: 12pt"><BR>=0A<DIV style=3D"FONT=
-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><FONT si=
ze=3D2 face=3DTahoma>=0A<HR SIZE=3D1>=0A<B><SPAN style=3D"FONT-WEIGHT: bold=
">From:</SPAN></B> Hemant K Chitale &lt;hemantkchitale@gmail.com&gt;<BR><B>=
<SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B> ORACLE-L &lt;oracle-l@free=
lists.org&gt;<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Wed,=
 November 10, 2010 8:43:09 PM<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Subje=
ct:</SPAN></B> Dynamic sampling<BR></FONT><BR>=0A<P>AARGH! </P>=0A<P>What y=
ou do when DBMS_XPLAN.DISPLAY_CURSOR shows a 190 line Plan with 205 entries=
 in the Predicates section&nbsp; and then adds "dynamic sampling used".</P>=
=0A<P>Just venting my frustration.<BR></P>=0A<P>Hemant K Chitale<BR>http://=
hemantoracledba.blogspot.com<BR>sent from my smartphone</P></DIV></DIV></di=
v><br>=0A=0A      </body></html>
--0-182500033-1289455805=:62189--
--
http://www.freelists.org/webpage/oracle-l