biggest transaction (was: Rollback Segments)

From: James Dickson <James.Dickson_at_mail.esrin.esa.it>
Date: Thu, 22 Apr 1999 12:08:25 +0200
Message-ID: <371EF519.7421@mail.esrin.esa.it>

On the topic of making tablespaces grow automatically, I use autoextend with the maxsize parameter set to a size which will not cause the O/S file system to fill up.

Regarding sizing rollback segments, Oracle write:

#
# The best solution for performance is to set all of your 
# rollback segments to a size where every single transaction will 
# always fit. In practical terms, this may well be impossible

at which point I have to ask: how can you tell how big your biggest transaction is?

James
--
james_at_valhall.esrin.esa.it.NOSPAM

Eike J. Heinze wrote:
>
> ... part of text omitted ...
>
> Rollback should be sized diligently.
>
> Regards Eike

dcard2_at_maine.rr.com wrote:
>
> Is there a way to make rollback segments/tablespaces grow automatically?
Received on Thu Apr 22 1999 - 05:08:25 CDT