Script – List SQL being executed by a particular SID

July 1, 2009 Gavin Soorma Scripts

col sql_text format a100 heading "Current SQL"
select q.sql_text
from v$session s
, v$sql q
WHERE s.sql_address = q.address
and s.sql_hash_value + DECODE
(SIGN(s.sql_hash_value), -1, POWER( 2, 32), 0) = q.hash_value
AND s.sid=&1;

Please follow and like us:

Last Update: July 1, 2009

July 1, 2009 252 Gavin Soorma

Total 0 Votes:

Tell us how can we improve this post?

Captcha: + = Verify Human or Spambot ?

Add A Knowledge Base Question !

Question Title:

Category:

Your Email: You will receive an email when your question will be answered.

Captcha: + = Verify Human or Spambot ?

current SQL, sql text, v$sql

Add A Knowledge Base Question !

Tell us how can we improve this post?

Related Knowledge Base Posts -

Add A Knowledge Base Question !

Leave a Comment Cancel reply

Add A Knowledge Base Question !