Re: FND_INSTALL_PROCESS and AD_DEFERRED_JOBS
- From: "Jurijs Velikanovs" <j.velikanovs@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Mon, 27 Aug 2007 19:05:16 +0300
It just a side effect passing through Apps DBA OCP examination ;)
It last I read the documentation and know that is written there :))))))
J.
On 8/27/07, Atul Kumar <atul_iiit@xxxxxxxxx> wrote:
>
> 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 <http://teachmeoracle.com/>
> Forum Dedicated to Apps DBA's <http://teachmeoracle.com/forum>
> [image: Become Apps
> DBA]<http://www.feedburner.com/fb/a/emailverifySubmit?feedId=465233>
--
Yury
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
Other related posts:
