Try the following...
select stxt.sql_text,username,osuser
from v$session sess, v$sqltext stxt
where stxt.address = sess.sql_address
and stxt.hash_value = sess.sql_hash_value
--Sathy
|
Results 1 to 3 of 3
Thread: how to get the dbms_jobs detailsThreaded View
|
Click Here to Expand Forum to Full Width |