VirtualObjectives

Searching User Activity and SQL

Searching for User Activity

The following scripts shows how to search for users by various attributes.
These scripts are suitable for Oracle 10G+.

Searching for SQL

The following scripts shows how to search for specific SQL statements by time, SQL, or SESSION_ID.
It is important to note that the data returned is not complete but taken from samples done by Oracle every second or so.