Re: Rollback Segment Question

From: <bdbafh_at_gmail.com>
Date: 25 Apr 2005 10:17:57 -0700
Message-ID: <1114449477.419394.67330@o13g2000cwo.googlegroups.com>

A question once asked of Abraham Lincoln:

Q: "How long should a man's legs be?"
A: "Long enough to reach the ground".

How many extents should be in a rollback segment, how large should the extents be?
Again, how large is your average "large" transaction? How many simultaneous transactions are there typically?

perhaps this is a case of where the "optimal" setting can help. Say that your "large" transaction uses 160M of undo. create the rollback segment tablespace with a uniform size of 8M, 20 extents and an optimal setting of 160M. If a second large transaction grows the rollback segment, it will eventually shrink back down to the optimal setting that you have set.

-bdbafh Received on Mon Apr 25 2005 - 12:17:57 CDT