Re: oracle upgrade

From: Gocha Mchedlishvili <gocham_at_mci2000.com>
Date: Wed, 10 Feb 1999 04:13:53 GMT
Message-ID: <5I7w2.232$mB5.9169@news.cwix.com>

We experienced the similiar problem, and reason was that ORACLE used COST optimizer instaed of RULE in almost all queries. After me made changes in initxxxx.ora
OPTIMIZER_MODE=RULE
everything went back to normal

Gocha

Naushi Hussain wrote in message <36C08FB0.DEF184F_at_Alliedsignal.com>...
>we went from 7.1.6 to 7.3.2. Some of the queries that took 5 minutes now
>take 10 to 12 mintues. nothing has changed. Is there anyone that can
>tell what we need to tune to get this right. The new version is supposed
>to be better.
>
Received on Tue Feb 09 1999 - 22:13:53 CST