Re: Finding users and their DML statements

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Sun, 19 Dec 2004 15:03:59 +0100
Message-ID: <ce2bs09mj5uvv1jdlvb3gohb2mnvv3ksh7@4ax.com>

On 19 Dec 2004 04:04:59 -0800, n_kselva_at_yahoo.com wrote:

>Hello,
>
>I am a startup DBA. I would like to know how to find out userwise DML
>statments.
>Like how many and who have issued "UPDATE" OR "DELETE" Statements.Like
>the following
>
>USER STATEMENT:
>Scott UPDATE
>INSERT
>
>Richard UPDATE
>
>etc.
>
>Is it possible to find out without using v$sql and like operator.?.
>Thanks in advance.
>
>Regards,
>Kumar.

No. The DML statements are in v$sql as long as there is room in the shared pool.
You'll need to use the logminer facility. OEM 9i comes with a graphical interface, so you don't need to find out and remember dbms_logmnr and dbms_logmnr_d calls.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Dec 19 2004 - 08:03:59 CST