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.