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



Other related posts: