-
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.
-
If you have different usernames for different affiliates, you can turn on database auditing and get the information.
-
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]
