Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Viewing current SQL in 10g while executing a dbms_job

Viewing current SQL in 10g while executing a dbms_job

From: Ignizio, Richard <richard.ignizio_at_PaeTec.com>
Date: Wed, 6 Sep 2006 10:01:44 -0400
Message-ID: <D63E582D09D77648A106C164FC7C483206990A27@mail1-corp.corp.paetec.com> 





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


Received on Wed Sep 06 2006 - 09:01:44 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US