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

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 29 Oct 2013 11:11:07 -0700
Message-ID: <CAORjz=NreZ2BaGuZ6b9stgDY2sWKiWG-nDjxqT9OOy2iQeWnUg_at_mail.gmail.com>

On Tue, Oct 29, 2013 at 8:32 AM, Chris Dunscombe <cdunscombe_at_yahoo.com>wrote:
> The reason is to do with audit and alerting based on thresholds of numbers
> of rows returned by queries. (Audit are asking).

that is a flawed (and probably useless) metric, at least IMO.

with subversive as (
  select count(*) salcount

  from hr.salaries s
  join hr.dept d on d.deptno = s.deptno
  where s.salary > 100000

)
select salcount from subversive

1 row returned, lots of information.

Might be worth discussing with the auditors.

That and the near impossibility of auditing on number of rows returned.

Do they really want to an audit on this:

with a as (

   select level c1 from dual connect by level <= 1000000 ) ,
b as (

   select level c1 from dual connect by level <= 1000000 )
select a.c1, b.c1
from a, b

I see lots of false positive from cartesian joins in their future.

Probably caused by queries written by auditors.

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

Received on Tue Oct 29 2013 - 19:11:07 CET