RE: Viewing current SQL in 10g while executing a dbms_job
- From: "Ignizio, Richard" <richard.ignizio@xxxxxxxxxx>
- To: "Anjo Kolk" <anjo.kolk@xxxxxxxxxxx>
- Date: Wed, 6 Sep 2006 10:19:02 -0400
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
<//www.freelists.org/webpage/oracle-l>
--
Anjo Kolk
Owner and Founder OraPerf Projects
tel: +31-577-712000
mob: +31-6-55340888
Other related posts:
