RE: How can you log number of rows returned by all queries?
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 28 Oct 2013 12:41:58 +0000
Won't work - unless you ensure you get the STAT lines generated for every
single execution of the statement, which can't be forced in all versions of
Oracle.
If you're going to end up with trace files then maybe you could parse out the
values for "r=" on FETCH lines where dep=0.
Regards
Jonathan Lewis
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Chris Dunscombe [cdunscombe@xxxxxxxxx]
Sent: 28 October 2013 12:33
To: tim@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: How can you log number of rows returned by all queries?
Hi Tim,
Sorry if I wasn't specific enough but I was meaning database user not an
application user which I think is what iSight is looking at. Having done some
more investigation myself the only idea I can come up with is setting SQL_TRACE
and then looing at the STAT lines with id=1 and looking the cnt value e.g.
STAT #4 id=1 cnt=6 pid=0 pos=1 obj=0 op='HASH JOIN RIGHT OUTER (cr=2024 pr=3
pw=0 time=0 us cost=254 size=2339298 card=1014)'
I was hoping there was something a little simpler.
Thanks,
Chris
On Monday, 28 October 2013, 11:39, Tim Gorman <tim@xxxxxxxxx> wrote:
Teleran iSight (http://www.teleran.com/products/iSight).
On 10/28/2013 2:41 AM, Chris Dunscombe wrote:
> Hi,
>
> Looking for a way of "logging" the number of rows returned by all queries run
> by a specific user, running 11.2.0.3?
>
> Any ideas anyone?
>
> Thanks,
>
> Chris
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l--
//www.freelists.org/webpage/oracle-l
Other related posts:
