Re: Audit some SELECT statements

From: GDN <gert.deneve_at_advalvas.be>
Date: Fri, 19 Nov 1999 21:46:35 +0100
Message-ID: <814d16$dg6$1@news0.skynet.be>

Maybe OEM + tuning/performance pack may help you.

Regards
Gert

Mike Glasser <mglasser_at_accmail.umd.edu> wrote in message news:38347EFD.A2EC8244_at_accmail.umd.edu...
> Is there an easy way to audit all the SELECT statements, EXCEPT those
> against the SYS objects? If not, is there a way to audit all the
> objects for a given schema owner? Not auditing a particular user, but
> instead auditing any SELECTS against any tables owned by SCHEMA1. If
> this is possible, I could then turn off system wide auditing and then
> just audit the particular owners I wanted. We have system auditing on
> and the selects against the SYS tables are filling up AUD$ to quickly
> for our taste. TIA.
>
> --
> Mike Glasser
>
> DBA - OIT, Operations & Enterprise Applications
> University of Maryland
> mglasser_at_accmail.umd.edu
>
>
Received on Fri Nov 19 1999 - 14:46:35 CST