[SQL] Oracle Query History

I have this Java application still communicating with Oracle 11g via JDBC code. With that said, wanted to check the queries made of this application on the Oracle history, if that already exists.

Key items to look at:

1. Full query (with parameter values (parsed and not ?), passed through java.sql.PreparedStatement)
2. Time of query
3. Schema used
4. User initiated the query

Expected Result:

• SQL query to run via SQL Developer (with SYSDBA rights or not) with the key all key items returned

Tried using the query below but it doesn't return the key items listed above:

select * from v$sql order by last_load_time desc

Continue reading...