how to find when and who run a sql_id ?
Hi all,
I'm trying to find which program or who put a mess in our Db by recompiling invalid objects (something our WF engine doesn't like at all).
I've found in dba_hist_sqltext some sql_id which could be potentially the culprit but when i try to search for it in DBA_HIST_SNAPSHOT i cannot find it at all ...
To be frank i'm not sure it's the right way to do it.
Is there an easy way to find when a particular sql_id was executed and if possible by who (any information like module will be useful).