Get list of queries to oracle database

Question

I use EF and Oracle.ManagedDataAccess to get/update/delete data from Oracle database.

How can I get history list of PL/SQL queries for this Oracle database ?

Answer 1

You can use this sql statement to get the history for any date:

SELECT * FROM V$SQL V where first_load_time LIKE '2015-05-04%';

Repeated: Find out the history of SQL queries

I don't know how to set the question as duplicated...