2012 wrote an article about Oracle e-business Suite concurrency manager, looking back to the previous summary of the content or relatively thin, many points did not say, recently in this piece of content, simply write a slightly complete article.
Benefits of the Oracle e-business Suite concurrency processing mechanism (current processing)Different from the ordinary function of the processing mechanism, the concurrency processing mechanism is actually an asynchronous processing mechanism, it put the program in the background to run, the front desk operation back to the user, allowing users to continue to do other business. Technically, the benefit of asynchronous processing is to reduce the load at a specific point in time and to increase the overall utilization of system resources. The sense that the asynchronous mechanism can effectively improve the overall use of feelings, reduce the user invalid waiting time.
What programs can use concurrency mechanisms to handle
Report ClassReport is a very personal thing, and generally is the most customer-specific parts of each company, if the report needs to develop a different list interface to query, display, then the workload will be huge. So Oracle embeds reports into concurrent processing, with a few flexible configurations or a small amount of development (Reports/bi Publisher Reports) to meet the needs of users ' various reports.
Process ClassMany are used for bulk transactions, or for long-running businesses, such as the Inventory Manager batch processing of temporary transactions in an interface table.
Two types of components of the concurrency processing mechanism (current processing) The concurrency processing mechanism (current processing) consists of two types of components:
- Concurrency Manager (Concurrent Managers)
- Concurrent requests (Concurrent requests)
Like the "manager" in the company, the manager arranges tasks for the worker and the worker is responsible for the specific execution. Concurrent managers in Oracle EBS is responsible for arranging the work, Concurrent requests responsible for specific execution.
classification of the Concurrency Manager (Concurrent Managers)A company generally has many managers, with high and low points, the president, Director, Manager, director .... Oracle EBS This enterprise also has many different levels of Concurrent manager, with the core Concurrent Managers management team (Internal Concurrent Manager, Standard Manager, Conflict Resolution mananger), there are common concurrent Managers. The core concurrent Managers team manages the common concurrent Managers below.
1. Core of three concurrency managers：
- Internal Concurrent Manager (internal manager) -the Master Manager is called the Internal Concurrent Manager (ICM) because it controls the behavior of all The other managers, and because the ICM are the boss, it must be running before any other managers can be activated. The main functions of the ICM is to start up and shutdown the individual concurrent managers, and reset the other manager s after one them have a failure.
- Standard Manager (STD manager) -another Important Master Concurrent Manager is called the Standard Manager (SM). The SM functions to run any reports and batch jobs, that has not been defined to run in any specific product manager. Examples of specific concurrent managers include the Inventory Manager, CRP Inquiry Manager, and the receivables tax Manag Er. It is a recommended to add specialization rules to the standard manager as it can cause problems.
- Conflict Resolution Manager (conflict resolution Manager) -the Conflict Resolution Manager (CRM) functions to check concurrent program definitions for incompatibility Ru Les. However, the ICM can be configured to take over the CRM's job to resolve incompatibilities.
Summary:
- Internal Concurrent Manager is the boss in the manager, the general owner, controls the operation of the other concurrency manager.
- Standard Mananger is a standard manager and is not included in the request of other specific managers (specific Concurrent Managers), which is managed by the standards Manager by default.
- Conflict Resolution Manager is primarily used to handle scheduling conflicts.
2. Concurrency Manager for a specific purpose (specific Concurrent Managers, SCM)In addition to the top three core concurrency managers, there are numerous specific-purpose concurrency managers, such as the Inventory manager (Inventory Manager), the receiving transaction manager (receiving Transaction manager), the MRP Manager, and a user-defined concurrency manager.
How the Concurrency Manager manages concurrent requestsThe process of concurrent requests from commit to run is like this: the user submits the concurrent program run request first, the concurrent request is placed in the request queue first, and the internal Concurrent manager finds the corresponding Concurrent according to the specific rules Manager (the standard manager, or a specific concurrency manager) to run these requests. A flowchart for managing concurrent requests for a typical concurrency manager:
definition of concurrency Manager
Concurrency Manager (Concurrent manager) = parameters (cache size, node settings ...) + Special rule (specialization rules) + working shift (work Shifts)
Definition path for Concurrency Manager: administrator----manager------------definition, which can also refer to the official documentation: Link. Take Inventory Manager as an example and define the interface for the inventory manager.
Cache Size:This number indicates how many requests each time the concurrency manager reads to run. Enter the number of requests your manager remembers each time it reads which requests to run. For example, if a manager's work shift has 1 target process and a cache value of 3, it would read three requests, and try T O Run those three requests before reading any new requests.
Tip:enter a value of 1 when defining a manager this runs long, time-consuming jobs, and a value of 3 or 4 for managers th At run small, quick jobs.
Node:This is the settings for the Concurrency Manager load balancer, which is the parallel Concurrent processing (PCP). If the server is multi-node, you can set the node in which the Concurrency Manager runs as the primary node and which node is the secondary node. If you is operating in a parallel concurrent processing environment and your want your manager to operate on a specific no De, select the name of the node. The primary node, if available, is the node your concurrent manager operates on. If The primary node or the database instance on it goes down, your concurrent manager migrates to its secondary node. Your concurrent manager migrates back to its primary node, that node becomes available.
Special rule (specialization rules)Concurrency management to include/exclude concurrent requests is set in.
working shift (work Shifts)In the Inventory Manager Concurrency Manager, the run shift determines the day and time that the concurrency Manager runs.
process (Processes):This field Oracle EBS Chinese translation of the problem, the official translation into the "process", I think translated into "process" better, this parameter indicates that for each shift, Concurrent Manager can invoke the maximum number of processes in the operating system layer to process requests concurrently.
Sleep seconds (sleep Seconds):Represents the time interval between shifts. The sleep time for your manager during this shift. Sleep time is the number of seconds your manager waits between checking the list of pending concurrent requests (Concurren T requests waiting to be started). Tip:set the sleep time to being very brief during periods when the number of requests submitted was expected to being high.
how to tell if the concurrency manager is working correctlySystem administrator responsibilities, Concurrent->managers->administer, if Target and actual are equal, and both are greater than 0, the concurrency Manager is the startup and running state.
- The Target column lists the number of processes that should is running for each manager for this particular workshift.
- The Actual column lists the number of processes that is actually running.
If the Actual column is zero and there is no processes running for this manager.
If the Target column is zero and then either a workshift have not been assigned to this manager, or the current workshift does Not specify any target processes.
If the target column is not zero and then the manager processes has either failed to start up,or gone down. One should check the manager ' s logfile and the ICM logfile. One can also search for OS processes using the ' ps ' command. It's possible for the form to being inaccurate, i.e. it may show actual processes even though they was not really running. When in doubt, check for processes at the OS level.
How to check the operation of concurrent Mananger under operating system
Whether the FNDLIBR process is started, which indicates whether the internal Concurrent manager process is running
Fndlibr:concurrent Manager
Ps-ef | grep FNDLIBR
FNDLIBR process indicates that concurrent mnagers is up and requests is running on the system. Sometimes it happens that even after stopping the concurrent managers by adcmctl.sh stop Apps/apps Some of the requests MI Ght continue running. In such cases your can wait for say 5 minutes and so if it dos not stop then you can kill those FNDLIBR processes Bykill -9 <processid>
Other Application Concurrent Manager
INVLIBR is the process for the following Managers
Manager to run Immediate Concurrent Programs defined in INVLIBR
[[email protected] ~]$ ps-ef | grep invlibr
oracle 7111 7004 0 Jul03? 00:00:07 invlibr
oracle 14016 13573 0 19:40 pts/5 00:00:00 grep invlibr
[[email protected] ~ ]$
Mrclib is the process for the following Managers
MRP Manager
[Email protected] ~]$ Ps-ef | grep mrclib
Oracle 7113 7004 0 Jul03? 00:00:06 Mrclib
Oracle 14024 13573 0 19:40 pts/5 00:00:00 grep mrclib
[Email protected] ~]$
PALIBR is the process for the following Managers
PA Streamline Manager
[Email protected] ~]$ Ps-ef | grep PALIBR
Oracle 7110 7004 0 Jul03? 00:00:06 PALIBR
Oracle 14003 13573 0 19:39 pts/5 00:00:00 grep palibr
[Email protected] ~]$
where is the log for the Concurrency Manager/concurrent request? Refer to Metalink Note 105133.1:concurrent processing-concurrent Manager Generic Platform Questions and Answers
- Where do concurrent request or manager logfiles and output files go?
- What is the logfile and output file naming conventions?
Current processing Tables
Table
|
Description
|
fnd_concurrent_requests
|
details of user requests, including status, start date, and completion date
|
fnd_concurrent_programs
|
fnd_concurrent_processes
|
cross-references between concurrent requests and queues,and a history of concurrent manager processes
|
fnd_concurrent_queues
|
information about each of the concurrent manager queues
|
You can also refer to my previous article: http://blog.csdn.net/pan_tian/article/details/7702103
Oracle delivers concurrency-related scripting-$FND _top/sql Scripts
- Afimchk.sql-tells the status of the ICM
- Afcmstat.sql-lists Active Manager processes
- Afrqrun.sql-lists all the running, waiting and terminating requests
- Afrqwait.sql-lists requests that is constrained and waiting for the ICM to release them.
- Afrqscm.sql-prints log file name of managers that can run a given request.
- Afcmcreq.sql-prints the log file name of the manager that processed the request
- Afrqstat.sql-summary of completed concurrent requests grouped by completion status and execution type:
- Afimlock.sql-lists locks that the ICM was waiting to get
- Afcmrrq.sql-lists managers that currently is running a request
Operating procedure: 1.sqlplus Apps/[email protected]
2.sql> @ $FND _top/sql/afimchk.sql
Referencespecialized/dedicated Concurrent Managers (Enhancing performance) Concurrent Manager in Oracle appsconcurrent Managers Wi Ndowbest practices for performance to Concurrent Managers in e-business Suite (Doc ID 1057802.1) Best practices for performance to Concurrent Managers in e-business suiteebs-technology area-webcast Record ing ' e-business suite-concurrent Manager performance-best practices ' [VIDEO] (Doc ID 1367676.1) Concurrent Manager Questions and Answers relating to Generic Platform [ID 105133.1]basic information about CONCU Rrent Managers (Doc ID 69336.1) Concurrent processing-concurrent Manager Generic Platform Questions and Answers (Doc ID 105133.1)
Reprint Please specify source: http://blog.csdn.net/pan_tian/article/details/42967585
About the Oracle e-business Suite concurrency processing mechanism (current processing)
