Re: Viewing current SQL in 10g while executing a dbms_job

Correct, oracle doesn't set the address in the v$session structure. If the direct memory attach programs like i3, ASH etc. dón't work.

Anjo.

On 9/6/06, Ignizio, Richard <richard.ignizio_at_paetec.com> wrote:
>
> Bug number 4888822, found it after I sent the initial question.
>
> So I am assuming there is no work around.
>
> -----Original Message-----
> *From:* akolk_at_oraperf.com [mailto:akolk_at_oraperf.com]*On Behalf Of *Anjo
> Kolk
> *Sent:* Wednesday, September 06, 2006 10:16 AM
> *To:* Ignizio, Richard
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: Viewing current SQL in 10g while executing a dbms_job
>
> Known bug, forgot the bug number.
>
> Anjo.
>
>
> On 9/6/06, Ignizio, Richard <richard.ignizio_at_paetec.com> wrote:
> >
> > Is there a way to view the current SQL that is executing while running a
> > DBMS_JOB in 10g? When you query v$session the sql_address is set to 00 and
> > the sql_hash_value is set to 0 for that session.
> >
> >
> > Oracle version: 10.2.0.2
> > server: UNIX
> > O/S: Sun Solaris 8
> >
> > Thanks,
> > Rich
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> Anjo Kolk
> Owner and Founder OraPerf Projects
> tel: +31-577-712000
> mob: +31-6-55340888
>
>

-- 
Anjo Kolk
Owner and Founder OraPerf Projects
tel:    +31-577-712000
mob: +31-6-55340888

--
http://www.freelists.org/webpage/oracle-l