• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 466
  • Last Modified:

Find Last 100 SQL Executions

Where do I look to find the last 100 SQL statements executed on a server?
  • 2
1 Solution
slightwv (䄆 Netminder) Commented:
Turn on auditing.

There is a last_active_time column in v$sql but the v$ views are dynamic and possibly unreliable.

You might also look at v$active_session_history with the same note above about V$ views.

There may also be some ADDM views that might have a history if you are licensed for ADDM.
xoxomosAuthor Commented:
I've requested that this question be deleted for the following reason:

Found an example.
xoxomosAuthor Commented:
Thanks.   Please ignore the delete request.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now