Saturday, May 15, 2021

I need to bounce ,status,changes of each Concurrent Manager

The status of the concurrent manager

SQL>select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name=‘Standard Manager’;

Deactivating the concurrent manager:When you deactivate a manager all requests (concurrent programs) currently running are allowed to complete before the manager(s) shut down.

SQL>update fnd_concurrent_queues set control_code='D' where concurrent_queue_name=‘Standard Manager’;

 

Set max and target processes to 0

SQL>update fnd_concurrent_queues set running_processes=0,MAX_PROCESSES=0 where concurrent_queue_name=‘Standard Manager’;

commit;

see the status of the Manager

SQL>select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name=‘Standard Manager’;

Activating the concurrent manager:

SQL>update fnd_concurrent_queues set control_code='R' where concurrent_queue_name=‘Standard Manager’;

commit;

 

See the status of the Manager

SQL>select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name=‘Standard Manager’;

No comments:

Table import and export.

Create Data Pump Directory. The first step in Oracle Data Pump is to create an OS level directory which will be used by Oracle for perform...