Oracle Apps Concurrent Processing:An Introduction
This article gives an introduction of Concurrent Processing in Oracle Application.
Concurrent Program:
An instance of an execution file, along with parameter definitions and incompatibilities. Several concurrent programs may use the same execution file to perform their specific tasks, each having different parameter defaults and incompatibilities.
Concurrent Program Executable:
An executable file that performs a specific task. The file may be a program written in a standard language, a reporting tool or an operating system language.
An execution method can be a PL/SQL Stored Procedure, an Oracle Tool such as Oracle Reports or SQL*Plus, a spawned process, or an operating system host language.
Concurrent Request:
A request to run a concurrent program as a concurrent process.
Concurrent Process:
An instance of a running concurrent program that runs simultaneously with other concurrent processes.
Concurrent Manager:
A program that processes user’s requests and runs concurrent programs. System Administrators define concurrent managers to run different kinds of requests.
There are many concurrent managers each monitoring the flow within each apps area.
But there are 3 MASTER CONCURRENT MANAGERS:
1. Internal Concurrent Manager (ICM): This is the one which monitors all other CMs
2. Standard Manager (SM) : This takes care of report running and batch jobs
3. Conflict Resolution Manager (CRM): checks concurrent program definitions for incompatibility checks.
We cannot delete a concurrent manager… but we can disable it… but it’s notrecommended.
Concurrent Queue:
List of concurrent requests awaiting to be processed by a concurrent manager.
Phases and Statuses through which a concurrent request runs:
A concurrent request proceeds through three, possibly four, life cycle stages or phases:
- Pending Request is waiting to be run
- Running Request is running
- Completed Request has finished
- Inactive Request cannot be run
Within each phase, a request’s condition or status may change. Below appears a listing of each phase and the various states that a concurrent request can go through.
Concurrent Request Phase and Status
Phase: PENDING
- Normal: Request is waiting for the next available manager.
- Standby: Program to run request is incompatible with other program(s) currently running.
- Scheduled: Request is scheduled to start at a future time or date.
- Waiting: A child request is waiting for its Parent request to mark it ready to run.
Phase:RUNNING
- Normal: Request is running normally.
- Paused: Parent request pauses for all its child requests to complete.
- Resuming: All requests submitted by the same parent request have completed running. The Parent request is waiting to be restarted.
- Terminating: Running request is terminated, by selecting Terminate in the Status field of the Request Details zone.
Phase:COMPLETED
- Normal: Request completes normally.
- Error: Request failed to complete successfully.
- Warning: Request completes with warnings. For example, a report is generated successfully but fails to print.
- Cancelled: Pending or Inactive request is cancelled, by selecting Cancel in the Status field of the Request Details zone.
- Terminated: Running request is terminated, by selecting Terminate in the Status field of the Request Details zone.
Phase:INACTIVE
- Disabled: Program to run request is not enabled. Contact your system administrator.
- On Hold: Pending request is placed on hold, by selecting Hold in the Status field of the Request Details zone.
- No Manager: No manager is defined to run the request. Check with your system administrator.
Different execution methods of executabls:
- FlexRpt The execution file is written using the FlexReport API.
- FlexSql The execution file is written using the FlexSql API.
- Host The execution file is a host script.
- Oracle Reports The execution file is an Oracle Reports file.
- PL/SQL Stored Procedure The execution file is a stored procedure.
- SQL*Loader The execution file is a SQL script.
- SQL*Plus The execution file is a SQL*Plus script.
- SQL*Report The execution file is a SQL*Report script.
- Spawned The execution file is a C or Pro*C program.
- Immediate The execution file is a program written to run as a subroutine of the concurrent manager.
Output formats of a concurrent program:
- HTML
- TEXT
- PS (Post Script)
- PCL(HP’s Printer Control Language)
1 comment:
Have you ever tried your hand playing online games? If not, then you've entered into the video game world with this article! There are tons of games and anyone can find something they like. In order to help you out, the following article will feature some information on the best games of each gaming genre.
Be sure to verify a game's rating prior to letting kids play. Some games contain violent or inappropriate content that is not intended for anyone under 18. Do not let your children play these games or watch while you play. If a game is violent, it can have negative affects on sleep and behavior of young kids.
If you want to sell your games on the Internet, you have to describe them in as much detail as possible. This description should include what type of condition the game is in and how it plays. Anyone who purchases this from you would like to be aware of these important details. By making your description as detailed as possible, you are increasing the odds that you'll sell your game.
Make online games part of your exercise routine. Physical motion sensing technology is spreading through the industry. That lets you engage in gaming while using your own muscles, playing sports and practicing yoga. You can now get into great shape using your video game in your living room.
It is important to take breaks and avoid excessive gaming playing. It's fairly easy to get addicted to a particular game, and this isn't healthy so you must get away from it every once in a while. Gaming is meant to be an enjoyable experience. Should you feel that addiction is an issue, speak to a medical professional about help.
Downloadable content (DLC) is available from many popular online games. Those are bells and whistles at an extra cost. Pay attention to the price tag before you buy. Some times buying DLC games can be two to three times more expensive than a single game.
Update your graphic drivers. If you do a lot of your gaming on your computer, you probably will want to have as clear a picture as possible. This is why you need the current graphic drivers. You can venture on over to the device manager section on your computer and see your latest graphic driver, then head to manufacturer's site to see if any new updates became available.
If you only play one or two genres of games, think about branching out. Most people tend to play just one kind of game. Trying out all sorts of video games makes it a lot of fun and a very rewarding experience.
If your child gets a game as a gift or if you are buying a gift, make sure to verify its ESRB rating. These ratings are designed to help you assess whether the game is appropriate for the players it is being bought for. This should be a definite consideration before making the purchase.
Buying a new game is tougher than you may think. You might waste a lot of money on a game you end up hating. Read game reviews before making a purchase.
Figure out how to operate the safety and parental controls of any gaming system that comes into your home. You can likely make adjustments that keep kids from viewing mature content. Some allow each gaming profile to be customized separately, allowing adults to enjoy games not meant for younger audiences.
No matter if you need to boost your grades, manage people and products, or get back at an enemy in the dark, computer games can truly make it happen! Put the suggestions and tricks of this article to good use in your world of gaming today.
Post a Comment