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

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

Known bug, forgot the bug number.


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: server: UNIX O/S: Sun Solaris 8



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

Other related posts: