Skip to Content
0
Jan 16, 2012 at 07:20 PM

Data Archiving Satistics/Trying to determine which tables to Re-organize

45 Views

Dear all,

We have just finished an exercise in archiving some FI data (FI_SL_DATA, EC_PCA_ITEM, CO_ITEM).The statistics indicate data deleted to be approx. 160GB. How do one find out from which tables, most of the records were removed from?

For example, for FI_SL_DATA, there are several tables with deletion..Which table had the most records removed, so that that specific table can be targeted for a DB re-org to free up the physical space? Are these granular statistics somewhere?

Thx!

Neeta