Re: Map dba_jobs entry to oracle process

johnleslie_at_madasafish.com (John Leslie) wrote in 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
>

I suspect it can be done by joining DBA_JOBS_RUNNING to V$PROCESS; but what do you hope/expect to gain by doing so? Received on Mon Jul 12 2004 - 08:11:56 CDT