I need to find the queries run against an Oracle instance.
On running the query:
SELECT first_load_time, sql_id, sql_fulltext FROM v$sql ORDER BY first_load_time ASC;
Only records from yesterday are displayed.
SELECT * FROM dba_hist_sqltext;
Gives absolutely nothing.
What can I do to get sql history over a longer period of time, say 2 months?