I have one that will show the sql that ran enough to show up in the dba_hist tables, but nothing that will show all SQL. On Fri, May 21, 2010 at 3:22 PM, Martin Berger <martin.a.berger@xxxxxxxxx>wrote: > without auditing or tracing I know no method to get ALL SQLs. > > you can use log miner to get the effect of all SQLs of the period, but you > does not get the SQLs. > > sorry, > Martin > > > Am 21.05.2010 um 21:17 schrieb Saad Khan: > > > Hi, >> >> We have several environments with 10g (10.2.0.4) in prod and non-prod,and >> we get advantage of AWR reports to get the top sqls that are run within any >> particular period. We've run into a situation when it seems that the >> developers ran some scripts which they are not supposed to. Now if we need >> to know all sqls that are run within any time duration to prove our point, >> say last 12 hours, I'm sure there must be a way. Can anyone help me in this >> regard? >> We dont have auditing in place. Is there any script that anyone likes help >> me with? >> >> >> Thanks. >> > > -- > http://www.freelists.org/webpage/oracle-l > > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'