RE: 10g vs 9i

Hi Ujang

I have seen this behaviour. It happens going from 9 to 10 at any level. In the case I had was due to things doing joins whose performance changed due to the effects of the optimiser.

You will have to take each case by itself and analyse it. I would consult with your business users for their worst performer and isolate the cause of that and then work back from there removing the most expensive issues

It is likely as you take it apart you may fix a number of issues at the same time

Look out for joins to v$ views as these performed badly

Cheers

Peter  

-----Original Message-----

From: Ujang Jaenudin [mailto:ujang.jaenudin_at_gmail.com] Sent: Tuesday, 12 June 2007 03:14 PM
To: oracle-l_at_freelists.org
Subject: 10g vs 9i

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

--

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