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

  • From: "Anjo Kolk" <anjo.kolk@xxxxxxxxxxx>
  • To: "Ignizio, Richard" <richard.ignizio@xxxxxxxxxx>
  • Date: Wed, 6 Sep 2006 16:30:03 +0200

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@xxxxxxxxxx> 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@xxxxxxxxxxx [mailto:akolk@xxxxxxxxxxx]*On Behalf Of *Anjo
Kolk
*Sent:* Wednesday, September 06, 2006 10:16 AM
*To:* Ignizio, Richard
*Cc:* oracle-l@xxxxxxxxxxxxx
*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@xxxxxxxxxx> 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
>
> --
> //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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2006