RE: performance in 10g
- From: <Govind.Arumugam@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Mar 2007 08:37:46 -0500
We ran into the similar problem in a WHSE environment but moved from 8i to 10g.
The recommendation from Oracle was to set the optimizer_feature_enable to
8.1.7; This was done about a month. We are still on this workaround through a
logon trigger for the app user. They use a generic id to login.
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
appuser > show parameter optimizer
NAME TYPE VALUE
------------------------------------ --------------------------------
------------------------------
optimizer_dynamic_sampling integer 0
optimizer_features_enable string 8.1.7
optimizer_index_caching integer 0
optimizer_index_cost_adj integer 75
optimizer_mode string CHOOSE
optimizer_secure_view_merging boolean TRUE
-----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® 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
Other related posts:
