"Michel Cadot" <micadot{at}altern{dot}org> wrote in message
news:40f29ce0$0$6180$626a14ce_at_news.free.fr...
>
> "John Leslie" <johnleslie_at_madasafish.com> a écrit dans le message de
> news:4412dd31.0407120447.3a1be6eb_at_posting.google.com...
> > Each entry on dba_jobs creates a Oracle process with a name like
> > ora_j001_sid.
> >
> > Is there any way to match the what column on dba_jobs to the
> > corresponding ora process?
> >
> > This is Oracle 9.2.0.4 on Solaris
>
> There is no static relation between job and job process (jxxx).
> The number of job processes is determined by the job_queue_processes
> parameters and not by the number of entries in dba_jobs.
>
> When a job is executed it is bound to a job process and
> you can see this relation in dba_job_runnings:
>
> select v$bgprocess.name, dba_job_runnings.job
> from v$bgprocess, v$session, dba_job_runnings
> where dba_job_running.sid=v$session.sid
> and v$session.paddr = v$bgprocess.addr
> and v$process.name like 'J%'
> /
>
> --
> Regards
> Michel Cadot
>
>
http://www.quest-pipelines.com/newsletter-v4/0403_C.htm
Received on Mon Jul 12 2004 - 17:57:33 CDT
