Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Number of queries for specific user
Hi all,
I would like to know if it's possible to find out
how many queries (SELECT, UPDATE, INSERT, DELETE)
a specific user (say SCOTT) has done since last
start.
I do not want to enable auditing - so the question
is if there is any view which can be queried.
RDBMS Version is 8.1.6.2.0 .
Thanks in advance ! Klaus
P.S. What do you think would be the performance loss if I would enable Auditing on an OLTP system ?
-- Klaus Naumann Database Administration GMX Aktiengesellschaft Riesstrasse 17, 80992 München Telefon +49.89.143 39-0 Telefax +49.89.143 39-100 mailto:knaumann_at_gmx-ag.de http://www.gmx.net/Received on Fri Feb 22 2002 - 08:09:07 CST