Re: SQLs run in any period
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: saad4u@xxxxxxxxx
- Date: Fri, 21 May 2010 22:22:37 +0200
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
Other related posts: