Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
Re: rollback segments and performance
Re: rollback segments and performance
Hi
- Make all Rollback segments the same size
- 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.
- Make sure that there is enough space for the rollback
segments to expand in the tablespace, if needed.
- set your optimal size to about the half of your initial
value and monitor the shrinks
- the initial and the next value should be set to the same
size
Regurads,
Mario Bucsics
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!
Received on Mon Sep 06 1999 - 12:13:07 CDT
Original text of this message