Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Number of queries for specific user

Number of queries for specific user

From: Klaus Naumann <knaumann_at_gmx-ag.de>
Date: Fri, 22 Feb 2002 15:09:07 +0100
Message-ID: <1esd8.1$id2.901@news.ecrc.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US