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 -> Rollback segment size

Rollback segment size

From: Frank Calfo <fcalfo_at_psateam.com>
Date: 12 May 1999 18:12:45 GMT
Message-ID: <01be9ca3$a0db9520$e4010180@frank>


Our database was created with 4 rollback segments with initial and next extent size of 128K.
I've noticed that highwater mark on them is approaching 30 MB and one just hit max extents limit.

In our case, seems like 128K for next extent is rather small.

Could I make it as large as 1MB or is that generally too large for a rollback segment?

Also, is settting unlimited extents on rollback a good or bad idea?

Thanks. Received on Wed May 12 1999 - 13:12:45 CDT

Original text of this message

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