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.