RE: performance in 10g

From: Job Miller <jobmiller_at_yahoo.com>
Date: Wed, 28 Mar 2007 09:29:51 -0700 (PDT)
Message-ID: <476073.74486.qm@web53912.mail.re2.yahoo.com>

Have you seen this?

http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_general_cbo_migration_10gr2_0405.pdf

Job
Govind.Arumugam_at_alltel.com wrote:
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

Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta.
--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 28 2007 - 11:29:51 CDT