Re: SQLs run in any period
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: martin.a.berger@xxxxxxxxx
- Date: Fri, 21 May 2010 16:01:10 -0500
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.'
Other related posts:
