Tuesday, April 29, 2014

View Last Query Executed – Oracle


Just a quick post on how to view recent queries run into an Oracle database:
 
SELECT sql_text, sql_fulltext
  FROM v$sql
ORDER BY last_load_time DESC

No comments:

Post a Comment