Re: RAC/EBS Application affinity options
- From: Jurijs Velikanovs <j.velikanovs@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Fri, 12 Jun 2009 10:41:05 +1000
Hello everyone,
Just to let you know that I am continuing to dig in that direction.
There are a few thinks I have done since last posts:
- Took a closer look and had a discussion on the R12.1.1 feature
mentioned bellow. Unfortunately it doesn't look like it brings us the
necessary functionality
- Found the following Enhancement Request logged 4 years ago. IMHP: It
is exact that Oracle should do to ensure proper CM-s RAC Affinity.
Bug No. 4159920 APPSRAP:PCP/CONCURRENT MANAGER - RAC NODE AFFINITY &
LISTENER LOAD BALANCING
- Logged a Service Request to work with Oracle to clarify the status
(as suggested by Steven Chan). As result of that status of ER 4159920
changed to "To Internal (Oracle) Review" recently :)
I will keep you posted,
Yury
On Tue, May 12, 2009 at 10:45 AM, Jurijs
Velikanovs<j.velikanovs@xxxxxxxxx> wrote:
> Hi List,
>
> I just was reading thought R12.1.1 New ATG features and found the
> following mentioned as R12.1.1 feature! :)
> REF: Doc ID: 561580.1 "Applications Technology RCD (v2.70"
> "Manager and Request Instance Affinity in Concurrent Processing"
>
> It looks like starting from R12.1.1 oracle supports RAC CP Application
> Affinity!
> I think it is a very good news!
>
> Just trying to find some detaled description in the documentation.
>
> I'll let you know if find anything,
> Y.
>
> On Thu, May 7, 2009 at 9:56 PM, Jurijs Velikanovs
> <j.velikanovs@xxxxxxxxx> wrote:
>> Hello everyone!
>>
>> I just decided to share my frustration on the the options available
>> from EBS side to support Application affinity. I welcome any comment
>> or experience from your side.
>> In the given context I call "Application affinity" an ability to
>> minimize RAC Interconnect traffic by running different modules
>> functionality on different nodes.
>> From my expiries "Application affinity" is one of the main performance
>> tuning methods available today and EBS have very limited options to
>> support it.
>>
>> I see 3 main technology stacks to talk about. Let me list those in the
>> order worse affinity support first:
>> - Self-Service (Html, JSP, Servlets, OAF) - no any control available.
>> All users connected to particular host use the same connection (one
>> TNS entry per Web Instance/Host).
>> - Concurrent Processing - CM-s from one node uses one TNS entry (one
>> RAC node or LB across multiple RAC nodes). If there are equal on more
>> CM-s nodes when RAC nodes you have full control of there to execute
>> particular CR by specifying CM and node for CM to execute on. If you
>> do have less CM-s nodes when RAC nodes you can't ensure full
>> Application affinity.
>> - Forms - the less problematic component as "Database ID" profile
>> options specify what DBC file to use. You can specify that profile
>> value on Site, Reponsability, Users levels. Fully controlling to what
>> RAC instance user or group of users to connect to.
>>
>> As far as I understand this is true for all currently available/used
>> EBS versions.
>> Generally speaking EBS doesn't have a good support of Application
>> Affinity (almost no support).
>> Am I right?
>>
>> Regards,
>> Yury
>>
>
>
>
> --
> Jurijs
> +371 29268222 (+2 GMT)
> ============================================
> http://otn.oracle.com/ocm/jvelikanovs.html
>
--
Jurijs
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
Other related posts:
