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.
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
Other related posts:
