Find Last 100 SQL Executions

Where do I look to find the last 100 SQL statements executed on a server?
Who is Participating?
slightwv (䄆 Netminder)Connect With a Mentor 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.

All Courses

From novice to tech pro — start learning today.