> Now i need some advice on how to analyse it.
>
> I see a table which has actually 20285 records (in the restored
> database) and in the old database it is showing 9800802 records:
>
> MV$DST1 (192)
> Primary pointer page: 525, Index root page: 526
> Average record length: 58.02, total records: 9800802
> Average version length: 18.52, total versions: 23, max versions: 2
> Data pages: 239097, data page slots: 239097, average fill: 76%

...

> I know this table has something wrong because i knew what to expect in
> the total records, but looking only to the information above, is there
> some number(s) that show me there is a lot of garbage in this table?

I can imagine only case - 9.8 mln inserts was rolled back. Unfortunately
gstat can't understand if records 'live' or 'dead'. You must have stuck OIT in
old database. After the sweep you'll see 20285 records in this table (if you
going to sweep it).

Regards,
Vlad