Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Number of queries for specific user
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