Re: FND_INSTALL_PROCESS and AD_DEFERRED_JOBS
- From: Atul Kumar <atul_iiit@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Mon, 27 Aug 2007 08:59:09 -0700 (PDT)
Thanks Jurijs for pointing members to this doc.
Atul
Jurijs Velikanovs <j.velikanovs@xxxxxxxxx> wrote:
Take a look on the following peace of Apps Doc Set.
Oracle(r) Applications
Maintenance Utilities
Release 11i (11.5.10.2)
Part No. B19300-01
Using Parallel Processing-> Managers
===============================================================
FND_INSTALL_PROCESS
===============================================================
The manager assigns each worker a unique ID and inserts a row for each
worker in the
FND_INSTALL_PROCESSES table. It creates this table to serve as a
staging area for
job information, and as a way to communicate with the worker. Communication is
accomplished using two columns: CONTROL_CODE and STATUS.
The manager updates the table with a subset of the list of jobs, one
job per worker. For
example, if there are five workers, then the table holds five jobs
(even though there
may be 100 or more jobs involved in the complete action). The manager starts the
workers and uses the CONTROL_CODE and STATUS columns to assign tasks. It polls
these two columns continuously, looking for updates from the workers.
As a worker
finishes its assignment, the manager updates each row with the next
task in the list,
and leaves another message for the worker.
Once all jobs are complete, the manager tells the workers to shut down, and then
drops the FND_INSTALL_PROCESSES table (after it is sure all workers
have actually
shut down).
===============================================================
AD_DEFERRED_JOBS
===============================================================
The deferred job feature uses the AD_DEFERRED_JOBS table. This table is created
when the FND_INSTALL_PROCESSES table is created, and is dropped when the
FND_INSTALL_PROCESSES table is dropped.
===============================================================
Jurijs
On 8/23/07, k srinivas wrote:
> Hi DBAs..
>
> The dynamic tables FND_INSTALL_PROCESS and AD_DEFERRED_JOBS are created
> when d driver is executed..
> Correct me if I am incorrect??
>
> What information these tables hold..Can anybody elaborate on this..
>
> Thanks in advance
> Sreenivash.
--
Yury
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
Atul Kumar
Site Dedicated to Apps DBA's
Forum Dedicated to Apps DBA's
Other related posts:
