question about automatic undo management

any rules of thumb on the undo_retention parameter? or do you play it by ear depending on your system and if you have long batches?

also, if Im using automatic undo management, does this totally eliminate the chance for snapshot too old? or does it restrict the odds of it happening? If your undo tablespace fills up, Im assuming it can happen? or will it automaticly increase the size of your tablespace?

how well does this work in practice? Received on Mon Jan 20 2003 - 08:03:33 CST