Identifying tables with high % of deletes/updates

Hi all, I am looking for a way to easily identify those tables on which a high % of inserts/deletes/updates occurred during the last time window (say 2 weeks). Somebody suggested using SMI table sysptprof, but according to the manual: "Profile information for a table is available only when a table is open. When the last user who has a table open closes it, the partition structure in shared memory is freed and thus any profile statistics are lost." Can anybody confirm that these statistics are in fact cleared at some stage and any suggestions on an alternative source of information? Thanks in advance. Sent via Deja.com http://www.deja.com/ Before you buy.

Try: oncheck -pT database:table It will show the unused space in the table. <evanrens@mibco.org.za> wrote in message news:8q7p3j$ef3$1@nnrp1.deja.com... > Hi all, > > I am looking for a way to easily identify those tables on which a high > % of inserts/deletes/updates occurred during the last time window (say > 2 weeks). Somebody suggested using SMI table sysptprof, but according > to the manual: > "Profile information for a table is available only when a table is > open. When the last user who has a table open closes it, the partition > structure in shared memory is freed and thus any profile statistics are > lost." > > Can anybody confirm that these statistics are in fact cleared at some > stage and any suggestions on an alternative source of information? > > Thanks in advance. > > > Sent via Deja.com http://www.deja.com/ > Before you buy.