reorganize snapshot log

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 01 Feb 2007 04:00:01 -0500
Message-ID: <9sa3s2lnesj680ievp13aa96m4vtcjk1kt@4ax.com>

The snapshot log has been cleaned up from 8mil rows.. (old snapshot references removed)

Is there are a way to do it, w/o upsetting the snapshots (there are a lot)? (w/o dropping the snapshot log)

Theoretically.. it's just a table, right? http://orafaq.com/node/4

system_at_VCRS> select count(*) from vcrs.MLOG$_MEMBER_SUMMARY;

COUNT(*)

Elapsed: 00:00:11.96

Statistics

          0  recursive calls
          0  db block gets
     124083  consistent gets
     118200  physical reads

.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Thu Feb 01 2007 - 03:00:01 CST