RE: How can you log number of rows returned by all queries?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 1 Nov 2013 16:35:36 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DC7AEE_at_exmbx05.thus.corp>

Look at Fine-grained Audit.
The overhead is significant, but it might be exactly what the auditors want.

Regards
Jonathan Lewis

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Chris Dunscombe [cdunscombe_at_yahoo.com] Sent: 29 October 2013 15:32
To: jkstill_at_gmail.com
Cc: Oracle-L Freelists
Subject: Re: How can you log number of rows returned by all queries?

Hi,

The reason is to do with audit and alerting based on thresholds of numbers of rows returned by queries. (Audit are asking).

Chris

On Monday, 28 October 2013, 20:31, Jared Still <jkstill_at_gmail.com> wrote: On Mon, Oct 28, 2013 at 1:41 AM, Chris Dunscombe <cdunscombe_at_yahoo.com>wrote:
> Looking for a way of "logging" the number of rows returned by all queries
> run by a specific user, running 11.2.0.3?
>

Why?

Or in other words, what is the underlying reason behind the request?

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 01 2013 - 17:35:36 CET