Re: Map dba_jobs entry to oracle process

"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