RE: performance in 10g

From: <Govind.Arumugam_at_alltel.com>
Date: Wed, 28 Mar 2007 08:37:46 -0500
Message-ID: <C8C159860377BD4CB874629A9C1DEACB0109E3A8@scarlitnt640.alltel.com>

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_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® 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 Received on Wed Mar 28 2007 - 08:37:46 CDT