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 '
Run Autoconfig.
No comments:
Post a Comment