Hey telemachus - kinda showing off your "mach"0 attitude, eh!
You don't own this board, so keep you trap shut if you don't like the guy's
post. You're NOT obliged to response. Using acronyms (RTFM) demonstrate a
very childish behaviour.
Remember, this board is here to help each other.
Try doing that at your job.
"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message
news:CnLb9.12536$zX3.23703_at_news.indigo.ie...
> RTFM for max DMRC on Redmond's finest.....
>
> "Tuning" <c_armanet_at_hotmail.com> wrote in message
> news:aknu9q$kqi$1_at_wanadoo.fr...
> > Hello,
> >
> > Oracle Enterprise Edition 8.1.7, Win 2K.
> >
> > I've had a query which was executed with a better explain plan with RBO
> than
> > CBO (and much faster!)
> > with stats on date, with compute option of course!; and I made some
> > optimization attempts on init.ora parameters.
> > Finaly, CBO worked well with parameter db_multiblock_read_count from 8K
to
> > 16K.
> >
> > Then, just for testing, I changed this parameter again, and leave it to
> 8K.
> > So, I was quite surprised when I saw the same explain plan (and
fastness)
> as
> > with 16K!!
> >
> > Any idea?
> >
> > Thanks.
> >
> > Regards,
> >
> > C.A.
> >
> >
>
>
Received on Fri Aug 30 2002 - 13:38:11 CDT