Thanks for the question, Enrico.
Asked: May 25, 2017 - 4:03 pm UTC
Last updated: May 26, 2017 - 1:30 am UTC
Version: Oracle Enterprise Edition 11.2.0.3.0
Viewed 1000+ times
You Asked
Hi
a customer of mine need to retrieve all queries executed and find which are the ones that return an empty result set
it means I've to catch each query, with it's bind variables values and it's results
the only solution I'm thinking is to set a trace for the session, but I can't examine the result of the tkprof, because it "cluster" results
must I examin the raw trace file, or there is some other workaround?
thanks in advance
and Connor said...
If you want all the bind variables for *each* execution, then examining the raw trace is going to be required, because they are not included in the tkprof-formatted results anyway.
Alternatively, you could look at using fine grained auditing (DBMS_FGA) which can capture SQL and binds. Plenty of examples on this site
Is this answer out of date? If it is, please let us know via a Comment