Re: performance in 10g

It is interesting to know datawarehouse like db running in RBO mode:)

Did you gather the statistics for 10g after the migration？ -- as you said in 9i you running rbo..

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of David Boyd
> Sent: Thursday, January 25, 2007 8:23 AM
> To: oracle-l_at_freelists.org
> Subject: performance in 10g
>
>
> Hi List,
>
> We upgraded our 9.2.0.6 database to 10.2.0.2. Our database is kind of
> data
> warehouse. We see worse performance for many queries that we benchmarked
> in
> 10g. We used rule-base optimizer in 9i and expected we have to tune some
> queries with cost-base optimizer individually. I was wondering what we
> can
> tune at database level first. We have done testing at various
> optimizer_index_cost_adj values and no big difference found. Any advice
> will be highly appreciated.
>
> Dave
>
> _________________________________________________________________
> Check out all that glitters with the MSN Entertainment Guide to the
> Academy
> Awards(r) http://movies.msn.com/movies/oscars2007/?icid=ncoscartagline2
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> ******************************************************************************************
> The information contained in this message, including attachments, may
> contain
> privileged or confidential information that is intended to be delivered
> only to the
> person identified above. If you are not the intended recipient, or the
> person
> responsible for delivering this message to the intended recipient, Alltel
> requests
> that you immediately notify the sender and asks that you do not read the
> message or its
> attachments, and that you delete them without copying or sending them to
> anyone else.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Regards
Zhu Chao
www.cnoug.org

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