Limit your Max Extent size

Want to limit your Max Extent size? Here's how!

Want to limit your Max Extent size? Use the init<SID>.dba file to add the parameter max_next_size ###M (where ### is the max size you want your extents to expand to).

Once you have changed this, run db13 sapdba -next (next extent) which will force all next extents above this size to reduce back to the max you have set in the parameter. This will also force any new extents to expand up to this level required to only reach this highwater mark. (note: if you set this too low you may find you are getting to many extents increasing rapidly, such as 300/550. In that case you may need to expand your size limit somewhat. This can be done online - test with your development system to gauge the effects.
This was last published in August 2003

Dig Deeper on SAP Basis administration and NetWeaver administration

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close