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 -> Finding users and their DML statements

Finding users and their DML statements

From: <n_kselva_at_yahoo.com>
Date: 19 Dec 2004 04:04:59 -0800
Message-ID: <1103454875.025650.245410@c13g2000cwb.googlegroups.com> 





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.
Received on Sun Dec 19 2004 - 06:04:59 CST












Original text of this message













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