How To Fix DB11017 - Segments with non-zero PCTINCREASE

DB11017 - Overview

• Message type: E = Error

• Message class: DB11 - Oracle Monitor: messages

• Message number: 017

• Message text: Segments with non-zero PCTINCREASE

What causes this issue?

The storage parameter PCTINCREASE is set for at least one segment in
the schema SAPR3. This can lead to tablespace fragmentation.

How to fix this error?

Start the analysis tool by double-clicking on the current node in the
monitoring tree. This will display a list of all segments whose
PCTINCREASE is set to a non-zero value.
Review this list to evaluate whether this setting is as intended.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DB11017 - Segments with non-zero PCTINCREASE ?

  The SAP error message DB11017 indicates that there are segments in the database that have a non-zero PCTINCREASE setting. This setting controls how much space is added to a segment when it needs to grow. A non-zero value can lead to issues with space management and can affect performance.
  
  Cause:
  
  PCTINCREASE Setting: The PCTINCREASE parameter is set to a value greater than zero for one or more segments in the database. This means that when the segment needs to grow, it will increase by a percentage of its current size rather than a fixed amount.
  Database Configuration: The database may have been configured in a way that is not optimal for the current workload or data growth patterns.
  Space Management: Non-zero PCTINCREASE can lead to fragmentation and inefficient use of space, which can cause performance degradation.
  
  
  Solution:
  
  
  Change PCTINCREASE to Zero: The most straightforward solution is to change the PCTINCREASE setting for the affected segments to