RE: How can you log number of rows returned by all queries?
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "cdunscombe@xxxxxxxxx" <cdunscombe@xxxxxxxxx>, "jkstill@xxxxxxxxx" <jkstill@xxxxxxxxx>
- Date: Fri, 1 Nov 2013 16:35:36 +0000
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@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Chris Dunscombe [cdunscombe@xxxxxxxxx]
Sent: 29 October 2013 15:32
To: jkstill@xxxxxxxxx
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@xxxxxxxxx> wrote:
On Mon, Oct 28, 2013 at 1:41 AM, Chris Dunscombe <cdunscombe@xxxxxxxxx>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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l--
//www.freelists.org/webpage/oracle-l
Other related posts:
