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

Have you a 'management document' of the implementation plan from 9i
single install to 10g rac is ?


As based doc I have used Note362203.1 Oracle Applications Release 11i
with Oracle Database 10g Release 2

For different reasons I have merged together patches listened below.
3107551  3453499  3865683  4334965  4461175  4619286  4653225  4709948
4712852  4864465  4888294  4895224  5187281
-- One of the reasons is to implement latest OATF patches like
"11i.AD.I.4", "11i.ATG_PF.H Rollup 3" and "TXK (FND) AUTOCONFIG
TEMPLATE ROLLUP PATCH M" at the same time implementing "11.5.10
INTEROP PATCH FOR 10GR2".

I've created two documents:
-- High level implementation plan (there implementation, testing,
troubleshooting phases, unavailability time for different environment
etc are reflected) for the organization management.
-- Low level (command by command) implementation instruction in order
to be able to pass this instruction to any of my colleagues to execute
it. I have described all steps like which commands to execute, which
errors can be ignored and how they have to be addressed later on.


Yury


I ask this because at this time, I too am trying to pull together all
the appropriate documentation. I know DBAs can just get stuff done by
following the odd metalink note, but I need to try and get an 'official'
nice thing for my management team.

BTW - with regard the below, you can also look into PLSQL Native
compilation - that will speed your PLSQL execution. As you are probably
aware, PLSQL is used a lot in Apps ;o)




On 5/26/06, Rolfe, Kent (GTI AIS OPS/SE) <kent_rolfe@xxxxxx> wrote: 
Have you a 'management document' of the implementation plan from 9i
single install to 10g rac is ?

I ask this because at this time, I too am trying to pull together all
the appropriate documentation. I know DBAs can just get stuff done by
following the odd metalink note, but I need to try and get an 'official'
nice thing for my management team.

BTW - with regard the below, you can also look into PLSQL Native
compilation - that will speed your PLSQL execution. As you are probably
aware, PLSQL is used a lot in Apps ;o)

-----Original Message-----
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Jurijs
Velikanovs
Sent: 26 May 2006 13:37
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: 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
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the sender, 
delete it and do not read, act upon, print, disclose, copy, retain or 
redistribute it. Click here for important additional terms relating to this 
e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------




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

Other related posts: