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

From: Anjo Kolk <anjo.kolk_at_oraperf.com>
Date: Wed, 6 Sep 2006 16:15:56 +0200
Message-ID: <54973d5e0609060715s67bb13d6vc11c9a8fc5ad1e50@mail.gmail.com>

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

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

Received on Wed Sep 06 2006 - 09:15:56 CDT

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