-----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
--
//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.
--
//www.freelists.org/webpage/oracle-l
