Re: How can you log number of rows returned by all queries?
- From: Chris Dunscombe <cdunscombe@xxxxxxxxx>
- To: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>, "jkstill@xxxxxxxxx" <jkstill@xxxxxxxxx>
- Date: Mon, 11 Nov 2013 15:43:16 +0000 (GMT)
Hi,
Thanks for that. I think I'll be suggesting that they don't pursue row counts
as it's quite easy to circumvent, given your XML trick, and not easy to do
anyway.
Cheers,
Chris
On Wednesday, 6 November 2013, 17:32, Jonathan Lewis
<jonathan@xxxxxxxxxxxxxxxxxx> wrote:
Well if I knew that they were checking by counting rows, I think I'd select an
XML transformation of the result of a query from dual whenever I wanted to see
some data and only ever return one row ;)
Which leads me to an approximation - "SQL*Net bytes sent to client". As a very
crude approximation, the number of rows may be roughly related to the number of
bytes. (And there goes my XML workaround).
Regards
Jonathan Lewis
________________________________
From: Chris Dunscombe [cdunscombe@xxxxxxxxx]
Sent: 06 November 2013 09:32
To: Jonathan Lewis; jkstill@xxxxxxxxx
Cc: Oracle-L Freelists
Subject: Re: How can you log number of rows returned by all queries?
In the case I'm looking at the auditors are interested in the number of rows
returned as the volume of data returned is an indicator of "dodgy" behaviour.
They don't tell me all the use cases their looking at, just ask me specific
technical questions about what's possible.
Other related posts: