Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: rollback segments and performance

Re: rollback segments and performance

From: Mario Bucsics <mario.bucsicsNOrjSPAM_at_siemens.at>
Date: Mon, 06 Sep 1999 10:13:07 -0700
Message-ID: <0146ce5a.48105b2a@usw-ex0102-014.remarq.com>

Hi

  1. Make all Rollback segments the same size
  2. Set the minextents to a value about 20 This is better for Performance bacause the Database do not have to allocate an extents if itīs ran out of space.
  3. Make sure that there is enough space for the rollback segments to expand in the tablespace, if needed.
  4. set your optimal size to about the half of your initial value and monitor the shrinks
  5. the initial and the next value should be set to the same size

 Regurads,

 Mario Bucsics

Received on Mon Sep 06 1999 - 12:13:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US