I need to see all queries coming to database. How to do that? I could not get proper results from a Google search.
Enable SQL Trace & all the queries coming to the database will be logged.
ALTER SESSION SET sql_trace = true; ALTER SESSION SET tracefile_identifier = mysqltrace;
The trace file will be present in the udump directory.
If you want to audit the database, look at my previous answer.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With