Re: SQLs run in any period

  • From: Saad Khan <saad4u@xxxxxxxxx>
  • To: Andrew Kerber <andrew.kerber@xxxxxxxxx>
  • Date: Fri, 21 May 2010 17:22:52 -0400

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

Other related posts: