RE: How can you log number of rows returned by all queries?
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: Chris Dunscombe <cdunscombe@xxxxxxxxx>, "jkstill@xxxxxxxxx" <jkstill@xxxxxxxxx>
- Date: Wed, 6 Nov 2013 17:20:33 +0000
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:
