Re: SQLs run in any period

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.'

Other related posts: