Re: Multi-Versions and Vacuum

If Oracle uses multiple version concurrency, then why does it appear to do
row locking (I use Oracle at work, but I do not admin it)

The only downside I have seen to MVCS is the extra disk space, but with
the performance improvements in a highly concurrent use environment, it is
well worth it.

Q: Does VACUUM FULL remove the rows that are too many for the FSM? Or,
are they just stuck? I know that regular VACUUM will not allow reuse of
overflowed rows. Also, how does one calculate the propper size for the
FSM?

______________________________________________________________________________

Your mouse has moved.
You must restart Windows for your changes to take effect.

#!/usr/bin/perl
print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);