Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Wednesday, August 22, 2012

Ensure Load Balancing Of Concurrent Manager Processes In PCP-RAC Configuration

How to make sure whether the conc process are getting load balanced or not?

SQL> conn apps/appspwdhere
Connected.
SQL> set linesize 1000
SQL> select inst_id, count(*)
from gv$session
where process in
(select os_process_id from fnd_concurrent_processes
where process_status_code = 'A')
group by inst_id;  2    3    4    5    6

   INST_ID   COUNT(*)
---------- ----------
         1         89
         2         92

If they are load balanced then.

1.Set the profile option "Concurrent: PCP Instance Check" to "OFF"
2.Set the context variable s_cp_twotask to ''  ( RAC service name which you created to load balance on the specific nodes/instances.

Run Autoconfig.

No comments: