Viewing current SQL in 10g while executing a dbms_job
- From: "Ignizio, Richard" <richard.ignizio@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 6 Sep 2006 10:01:44 -0400
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
- Follow-Ups:
- Re: Viewing current SQL in 10g while executing a dbms_job
- From: Anjo Kolk
Other related posts:
- » Viewing current SQL in 10g while executing a dbms_job
- » Re: Viewing current SQL in 10g while executing a dbms_job
- » RE: Viewing current SQL in 10g while executing a dbms_job
- » Re: Viewing current SQL in 10g while executing a dbms_job
- Re: Viewing current SQL in 10g while executing a dbms_job
- From: Anjo Kolk