DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: data dictionary for DML performed

  1. #1
    Join Date
    Feb 2006
    Posts
    86

    data dictionary for DML performed

    hi

    which data dictionary will give information about what DML operations are performed on a particular table.
    for Ex: if a user has inserted or updated a record in a table, i want to see the information about the DML performed.


    Thanx in advance

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you cannot, those things are not recorded in any table, if you really want to see the DML statements you have to mine the logs using logminer

  3. #3
    Join Date
    Feb 2006
    Posts
    86
    my requirement was that i wanted to see what DML operations are performed on the Table and not the DML statement. like when last insertion was performed , when last updation was performed on the table. basically Audit sort of things

  4. #4
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    Then either use database audit or write your own triggers on those tables

    for auditing use foll

    http://download-uk.oracle.com/docs/c...6521/audit.htm

    If you go for triggers you should know your business requirements as trigger will fire for every single DML and may degrade your performance. Audit also makes performance bit slower.
    Last edited by paragp1981; 12-20-2007 at 06:59 AM.
    Rgds
    Parag

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width