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

Thanks for that idea re the FETCH lines.

BTW why aren't STAT lines always generated and how would you force it in those versions of Oracle which can be forced.

Thanks again,

Chris

On Monday, 28 October 2013, 12:43, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:

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_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Chris Dunscombe [cdunscombe_at_yahoo.com] Sent: 28 October 2013 12:33
To: tim_at_evdbt.com; oracle-l_at_freelists.org 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_at_evdbt.com> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l