RE: How can you log number of rows returned by all queries?
- From: "Stephens, Chris" <Chris.Stephens@xxxxxxx>
- To: "yong321@xxxxxxxxx" <yong321@xxxxxxxxx>, "cdunscombe@xxxxxxxxx" <cdunscombe@xxxxxxxxx>
- Date: Tue, 5 Nov 2013 07:40:59 -0600
" The problem with this approach is that if the session exited, you lose its
data"
Logoff trigger?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Yong Huang
Sent: Tuesday, October 29, 2013 11:32 AM
To: cdunscombe@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: How can you log number of rows returned by all queries?
> Looking for a way of "logging" the number of rows returned by all queries run
> by a specific user, running 11.2.0.3?
Chris,
How about checking statistic 'table scan rows gotten' for the user's sessions?
Join v$session and v$sesstat (and v$statname if you don't want to hardcode
statistic# for your version).
The problem with this approach is that if the session exited, you lose its
data. You either have to sample more frequently (and replace the value for the
same session sampled last time in your record) to minimize this problem, or
make sure most other sessions rarely disconnect and get the value for this stat
from v$sysstat instead, minus the values for the long-connecting sessions.
Why number of rows? How about logical reads, which you can get from
dba_audit_(session|trail) if you have audit turned on, which is default in 11g?
Yong Huang
--
//www.freelists.org/webpage/oracle-l
CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is privileged,
confidential and exempt from disclosure under applicable law. If the reader of
this message is not the intended recipient or the employee or agent responsible
for delivering this message to the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this communication is
strictly prohibited. If you have received this communication in error, please
notify us immediately by email reply.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
