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

From: Chris Dunscombe <cdunscombe_at_yahoo.com>
Date: Tue, 29 Oct 2013 15:32:25 +0000 (GMT)
Message-ID: <1383060745.39716.YahooMailNeo_at_web28704.mail.ir2.yahoo.com>

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

Received on Tue Oct 29 2013 - 16:32:25 CET

This message: [ Message body ]
Next message: Backseat DBA: "context switching (attempt 2)"
Previous message: Chris Taylor: "Re: Filesystem blocksize for archive logs on AIX"
In reply to: Jared Still: "Re: How can you log number of rows returned by all queries?"
Next in thread: Jared Still: "Re: How can you log number of rows returned by all queries?"
Reply: Jared Still: "Re: How can you log number of rows returned by all queries?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message