Re: Tuning SQL in Oracle
Date: Thu, 31 Jul 2003 00:34:56 GMT
Message-ID: <QuZVa.23181$o%2.12659_at_sccrnsc02>
Hard to know if we don't see the explain plan and tkprof outputs.(and the
sql)
Jim
"jag" <7bf79m4s02_at_sneakemail.com> wrote in message
news:n89givo5c0nihtkrbetgm5vbjek400udrf_at_4ax.com...
> On Wed, 30 Jul 2003 18:46:33 +0000, LKBrwn_DBA
> <member30625_at_dbforums.com> wrote:
>
> >
> >Hint:
> >
> >Analyze all tables and indexes.
>
> That's what got me into this. :) My code starting dragging on our
> production database right after a analyze had taken place. Apparently
> we were right under a certain level of data before the analyze was run
> that the new stats took us past. At that point I guess the CBO chose a
> very bad access path.
>
> >http://www.amazon.com/exec/obidos/ASIN/0130123811/qid=1059590327/sr=2-3-
> >/ref=sr_2_3/103-8017330-2186264
>
> Thanks. I just ordered one. This book is a couple of years old though.
> Has the CBO changed much for 9i?
Received on Thu Jul 31 2003 - 02:34:56 CEST