performance in 10g

From: David Boyd <davidb158_at_hotmail.com>
Date: Thu, 25 Jan 2007 08:23:23 -0500
Message-ID: <BAY101-F299247EB81CE90A7440E11EFA30@phx.gbl>

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® http://movies.msn.com/movies/oscars2007/?icid=ncoscartagline2

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

Received on Thu Jan 25 2007 - 07:23:23 CST