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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of David Boyd
Sent: Thursday, January 25, 2007 8:23 AM
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts: