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

From: <tim_at_evdbt.com>
Date: Mon, 28 Oct 2013 08:57:39 -0700
Message-Id: <20131028085739.c84976551849b6e0eb4ffca8ddbd2981.9307d7b8e3.wbe_at_email01.secureserver.net>



 The Teleran product does a pass-thru on all inbound and ou= tbound traffic at the TNS layer, so it is able to keep track of all in= bound SQL and returned rows between application users and connected da= tabase account name, so it is aware of identity on both sides of the TNS la= yer.=0A =0AFWIW, the associated "iGuard[1]" produc= t even allows you to intercept incoming SQL, modify returned error codes, o= r redact data from retrieved rows.=0A =0AI'm not= a Teleran shill, but I've been working with it on-and-off for about 10 yea= rs.=0A =0A =0A=0A-------- Original Message

Subject= : Re: How can you log number of rows returned by all queries? From: Chri= s Dunscombe <cdunscombe_at_yahoo.co= m[2]> Date: Mon, October 28, 2013 6:33 am
To: "tim_at_evdbt.com[3]" <tim@= evdbt.com[4]>, "oracle-l_at_free= lists.org[5]" <oracle-l_at_fr= eelists.org[6]>
Hi Tim,

Sorry if I wasn't specific enough= but I was meaning database user not an application user which I think is w= hat iSight is looking at. Having done some more investigation myself the on= ly idea I can come up with is setting SQL_TRACE and then looing at the STAT= lines with id=3D1 and looking the cnt value e.g.

STAT #4 id=3D1 cnt= =3D6 pid=3D0 pos=3D1 obj=3D0 op=3D'HASH JOIN RIGHT OUTER (cr=3D2024 pr=3D3 = pw=3D0 time=3D0 us cost=3D254 size=3D2339298 card=3D1014)'

I was= hoping there was something a little simpler.

Thanks,

Chris

On Monday, 28 October 2013, 11:39, Tim Gorman <tim_at_evdbt.com[7]> wrote: Teleran iSight (http://www.teleran.com/prod= ucts/iSight).

On 10/28/2013 2:41 AM, Chris Dunscombe wrote:> Hi,
>
>Looking for a way of "logging" the number of ro= ws returned by all queries
run by a specific user, running 11.2.0.3? &gt= ;
>Any ideas anyone?
>
>Thanks,
>
>Chris> --
>htt= p://www.freelists.org/webpage/oracle-l[8]
>
>
>
>

--
http://w= ww.freelists.org/webpage/oracle-l[9]


--- Links ---
   1 3D"http://http://www.teleran.com/products/iGuard"
   2 3D"mailto:cdunscombe_at_yahoo.com"
   3 3D"mailto:=
   4 3D"mailto:tim_at_evdbt.com"
   5 3D"mailto:oracle-l_at_freelists.org"
   6 3D"mailto:oracle-l_at_freelists.org"
   7 3D"=
   8 3D"http://www.freelists.org/webpage/oracle-l"
   9 3D"http://www.freelists.org/webpage/oracle-l"
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 28 2013 - 16:57:39 CET

Original text of this message