Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Rollback segment size
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
![]() |
![]() |