Re: Rollback segs #/sizes?

js wrote:
> Yes. You take a "pot shot" at it knowing that you should have about 1 RBS
> for every 4 users with no more than 50 RBSs. and then you monitor
> v$rollstat. v$rollstat tells you how many times the RBS has wrapped
> (extended) and shrunk (gone back to "optimal"). you adjust the size of the
> RBS so that you do not have any wraps or shrinks. :) but this is not
> always possiable. you should have at lease one large RBS and make the
> developers use "set transaction" when using long running SQL to force the
> SQL to use the big RBS. otherwise you will get Snapshot too old...
 

> Andrew Lenz

Thanks for the responses. As I said, I had a hard time believing that the dbas I've worked with would go through that; but, you never know!

Thanks again for the response and tips.

Doug

-- 
------------------------
Douglas K. O'Leary
Senior System Administrator
dkoleary_at_mediaone.net