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 -> Re: Number of queries for specific user

Re: Number of queries for specific user

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 22 Feb 2002 18:47:28 +0100
Message-ID: <3t0d7ukihlrsr4qvn27mc2stgaalso7o3r@4ax.com>


On Fri, 22 Feb 2002 15:09:07 +0100, Klaus Naumann <knaumann_at_gmx-ag.de> wrote:

>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 ?

There is NO view.
The performance loss is measurable, as the sys.aud$ table will become the bottleneck in your system.
8.1.6 has been desupped.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Feb 22 2002 - 11:47:28 CST

Original text of this message

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