Re: Benefit going for oracle Database 10g with 11i applications

Hi Rohit,

I am doing 10G R2 implementation in a 11.5.10.2 environment at the moment.
Some general ideas:
-- It is time then 10G became reliable enough to implement it in the
production (R2 + first patch released 1/2 year ago).
-- Optimizer in 10G is smarter the in 9i and generally speaking 98% of
your SQL-s will have better or the same performance.
  For as it is actual in terms of Discoverer reports. We have got a
lot of them and some are not preforming well.
  Just one example: The Disc Report with 500 rows in an execution
plan executes within 10 hours in our current production environment. I
have tried to execute the same report on upgraded test environment and
it took 5 sec to complete (the same SQL on the same DATA)
-- Looking back in history we can assume that this version of Oracle
RDBMS will be supported longer then any available today and any wich
will appear in nearest feature.

Just some general ideas.
Today I have to finish upgrading functional test environment and let
business to run tests.
The testing results expected within next 2 weeks.

Yury


On 5/26/06, Rohit Goyal <rgoyal_dba@xxxxxxxxx> wrote: 


Hi, folks,
We currently have Oracle Applications 11i, (11.5.10.2) with database 9i
(9.2.0.6). We are thinking about going for 10g but we are not sure whats the
benefit we will get.
If any one has done some research on it, or has some documents then can you
please share with me. Before we decide to move to 10g, I want to make sure
it is right thing to do. If we don't move to 10g, what we will miss, or what
will be impact in future.
Any comment will be helpful.
Thanks,

Regards,
Rohit



--
Yury
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html

Other related posts: