But as the AWR report shows top 5 sqls, what if we change the script to show say 20 sqls, if not all. On Fri, May 21, 2010 at 5:01 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>wrote: > 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. >>> >> >> -- >> //www.freelists.org/webpage/oracle-l >> >> >> > > > -- > Andrew W. Kerber > > 'If at first you dont succeed, dont take up skydiving.' >