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

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 <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:19:02 CDT