Skip to content

Instantly share code, notes, and snippets.

@icoxfog417

icoxfog417/gist:6127898

Last active December 20, 2015 11:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save icoxfog417/6127898 to your computer and use it in GitHub Desktop.
Save icoxfog417/6127898 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle executing SQL
Raw
gistfile1.sql
--SQL
select sid,serial#,username,logon_time,q.SQL_ID,q.SQL_TEXT
from v$session s,v$sql q
where s.SQL_ID=q.SQL_ID
--SQL ALL
select SQL_TEXT from v$sqltext b WHERE b.SQL_ID = :pId ORDER BY PIECE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment