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

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