Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the recommended size for MINEXTENTS to reduce the possibility of rollback segment extension?

April 26, 2017extension minextents POSSIBILITY recommended reduce Rollback segment size

0

Posted

What is the recommended size for MINEXTENTS to reduce the possibility of rollback segment extension?

1 Answer

0

Posted

20 MINEXTENTS for a rollback segment should be greater than or equal to two. Oracle recommends a value of 20 to reduce the likelihood of extension. OPTIMAL should be greater than or equal to MINEXTENTS. PCTINCREASE cannot be specified and should be set to zero. INITIAL should always be equal to NEXT. All the extents allocated to a rollback segment should be the same size. Place rollback segments in tablespaces that do not contain data to minimize I/O contention and fragment.