10g vs 9i

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Tue, 12 Jun 2007 12:13:33 +0700
Message-ID: <3edcb66e0706112213x3730ae1axfe81769e1c3008ea@mail.gmail.com>

all,

recently i have a dev machine 10g on itanium ia-64 another linux is itanium ia-64 with 9i

the performance on 10g (10.2.0.3) is dropped for almost 1/3 from the 9i, if someone has the same experiences, pls share....

all these parameters doesn't help either... alter system set optimizer_features_enable='9.2.0' scope=both; alter system set "_optimizer_cost_based_transformation" =on scope=both; alter system set "_gby_hash_aggregation_enabled" = TRUE scope=both;

--

regards
ujang
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jun 12 2007 - 00:13:33 CDT