How to list tables based on DML activity

[jt]

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.

[sln81]

If you have different usernames for different affiliates, you can turn on database auditing and get the information.

[sreddy]

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]