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

Thread: How to list tables based on DML activity

  1. 02-08-2001, 06:36 PM #1
    jt
    jt is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 02-08-2001, 06:43 PM #2
    sln81
    sln81 is offline Member
    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.
    Reply With Quote Reply With Quote
  3. 02-08-2001, 07:35 PM #3
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    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]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width