Re: Rollback Segment Setup Questions

From: Andy Bowles <andy.bowles_at_virgin.net>
Date: Sat, 26 Feb 2000 18:22:36 -0000
Message-ID: <8997ss$7q5$1@nclient13-gui.server.virgin.net>

Niall wrote in message <895jbe$i5p$1_at_soap.pipex.net>...
>the general rule is the rule of 4. 1 rollback segment for every 4
active
>users of the database. There is an upper limit of 50 rollback segments
>recommended by Oracle. Sizing is more difficlt because it depends on
usage
>patterns, but I would recommend smallish equally sized rollback
segments for
>an OLTP system with perhaps a couple of large ones offline that can be
>brought online for any batch processing that is required.

If space is plentiful, is there any benefit to having small rollback segments (or small extents within a rollback segment) rather than large ones? Will small transactions experience better performance if the rollback segment is sized appropriately? Received on Sat Feb 26 2000 - 12:22:36 CST