ORA-1555 Snapshot too old

From: Luis Santos <lsantos_at_pobox.com>
Date: Wed, 25 Nov 1998 03:23:03 -0800
Message-ID: <wGW62.2518$ri1.1612503@WReNphoon2>

Use larger rollback segments with 20 or more extents(try, first, 40M segments with 20 2m extents) and DO NOT USE optimal parameter. Instead, write a script to manually shrink your rollback segments and run it when no transaction are running.

Best regards
Luis Santos

-**** Posted from Supernews, Discussions Start Here(tm) ****- http://www.supernews.com/ - Host to the the World's Discussions & Usenet Received on Wed Nov 25 1998 - 05:23:03 CST