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

Rolfe,

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)

I am VERY, VERY SCEPTICAL on using that feature.
In one of our Core Oracle projects (non Apps, 9.2.0.5 Solaris) we have
tried to enable native compilation for Java objects. The performance
gain wasn't there. Looks like this feature are good only on paper.
Maintenance overhead however are HUGE !
I expert that PL/SQL native compilation in such complex system as Apps
is can bring more problems than positive impact.

I would say lets finish our 10GR2 + RAC enabling projects and then we
can have another try of Native compilation in test environment.
But I wouldn't expect something extremely beneficial in that context.
I am VERY, VERY SCEPTICAL on using that feature.

PS I would be glad if someone can justify opposite.

Yury




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: