How To Fix DB11017 - Segments with non-zero PCTINCREASE

SAP Error Message - Details

• 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 zero. This will ensure that the segments grow by a fixed amount rather than a percentage, which can help manage space more effectively.
  
  You can do this using SQL commands or through the database management tools, depending on the database system you are using (e.g., Oracle, SQL Server, etc.).
  
  Example SQL command for Oracle:
  ALTER TABLESPACE your_tablespace_name
  MODIFY (PCTINCREASE 0);
  
  
  Monitor Space Usage: After making changes, monitor the space usage of the segments to ensure that they are growing as expected and that there are no further issues.
  
  
  Database Maintenance: Regularly perform database maintenance tasks such as reorganizing segments, checking for fragmentation, and optimizing space usage.
  
  
  Consult Documentation: Refer to the specific database documentation for detailed instructions on managing segment settings and understanding the implications of PCTINCREASE.
  
  
  Related Information:
  
  Database Management: Understanding how your specific database system handles segments and space allocation is crucial. Each database may have different commands and best practices.
  Performance Tuning: Adjusting segment growth settings can be part of broader performance tuning efforts. Consider other parameters that may affect performance and space management.
  SAP Notes: Check SAP Notes and documentation for any specific recommendations or patches related to this error message, as SAP may provide updates or best practices for managing database configurations.
  
  By addressing the PCTINCREASE setting and monitoring the database, you can resolve the DB11017 error and improve overall database performance.