Skip to content

Instantly share code, notes, and snippets.

@katjunior

katjunior/oracle_sql_text_spid.sql

Created September 18, 2013 16:00
Show Gist options
  • Save katjunior/6611362 to your computer and use it in GitHub Desktop.
Save katjunior/6611362 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle - Select Sql Text from System Process ID
Raw
oracle_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='6495')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment