Hi,
App team wants to find out the list of sql queries executed by the users for the time interval between 10 am to 10 pm for ORCL database.
( for example U1 user logged at 10 am run some SQL queries then disconnect again connect to database run some sql queries and disconnect..).
Here i want to find out all the queries run by the users in specific database. Please provide the SQL query or script to find the details.
There are 10 databases running on this server and ORCL database in one among them.
No auditing is enabled.
No logminer.
Regards,
Bala