Re: How can you log number of rows returned by all queries?
- From: Chris Dunscombe <cdunscombe@xxxxxxxxx>
- To: "tim@xxxxxxxxx" <tim@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 28 Oct 2013 12:33:09 +0000 (GMT)
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
Other related posts:
