How to list tables based on DML activity
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to list tables based on DML activity

  1. #1
    Join Date
    Oct 2000
    Posts
    76
    Could you point me to a method/script that will list tables based on DML activity on them? I have 10 tablespaces based on 10 business affiliates, and each aff. has the same set of applications as tables in each tablespace. I need to find out which application (as the total from all affiliates, therefore across all tablespaces) is the most active in terms of DML activities. So tablespace or datafile level i/o sort won't work.

    Thanks for the help.

  2. #2
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    If you have different usernames for different affiliates, you can turn on database auditing and get the information.

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Oracle 8i Log Miner which can be used against version 8 is an option to track the changes to dataabse. If its 734 auditing is the only option with performance degradation as an issue.

    [Edited by sreddy on 02-08-2001 at 06:59 PM]

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