Skip to content

Instantly share code, notes, and snippets.

@katjunior

katjunior/sql_text_spid.sql

Created October 1, 2013 12:16
Show Gist options
  • Save katjunior/6777578 to your computer and use it in GitHub Desktop.
Save katjunior/6777578 to your computer and use it in GitHub Desktop.
Download ZIP
SQL por tras do processo
Raw
sql_text_spid.sql
select s.sql_text,s.sql_fulltext from v$sql s
where sql_id in(SELECT A.SQL_ID FROM V$SESSION A,V$PROCESS B
WHERE A.PADDR=B.ADDR AND B.SPID='32507')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment