Obtain all list of queries run on the database in history.
856889Apr 21 2011 — edited Apr 21 2011Good day to all of you.
This is my first post here.
We have an application where we need to study the set of all queries that were run successfully on the DB by users of that db.
In particular, SELECT stats that were run on the DB Tables/Views...
Therefore, does Oracle have a 'Query History' of some sort where SQL statements are stored in archives or something like that?
If so, for how many days of data does it store ?
Is the DBA_HIST_SQLTEXT View useful ? I took a look at it, however, it did not seem to store any of the queries that were run
by users. It had some DML statements that i am sure were not run by any of the users.
Any help in this regard would be greatly appreciated as this is central to what we wish to implement in the future.
Thank you.
Karan.