« Recursive quicksort | Home | Unix: get the file date »
Oracle: text of the running SQL queries
SELECT s.sid, s.serial#, st.sql_text sql_text
FROM v$session s, v$sql st, v$process p
WHERE s.sql_hash_value = st.hash_value
AND s.sql_address = st.address
AND s.paddr = p.addr
and ( s.sid=&which_sid. )
Full text
select x.sql_text
from v$session s,v$sqltext x
where s.sql_address=x.address and s.sid = &which_sid
order by sid, piece asc
Topics: Oracle | Submitter: checkthis
Comments
You must be logged in to post a comment.
