
	Home > SAP software/management Tips > SAP Basis administration tips > Limit your Max Extent size

SAP Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

SAP BASIS ADMINISTRATION TIPS

Limit your Max Extent size

Tanya Moncrieff
08.08.2003
Rating: -4.00- (out of 5) Hall of fame tip of the month winner

Digg This!

StumbleUpon

Del.icio.us

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.

Rate this Tip
To rate tips, you must be a member of SearchSAP.com. Register now to start rating these tips. Log in if you are already a member.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	SAP Basis administration tips
	Converting from MDMP to Unicode
	Can SAP developer include authority check for S_TCODE in a called transaction?
	How to fix Smart Forms printing double purchase orders
	Deriving the name of a Smart Style from a Smart Form
	SAP FI/CO consultant's role during upgrade from R/3 to ECC 6.0
	Alternatives to downloading a trial version of SAP IDES ERP software
	Verifying data consistency in production SAP FI/CO system when restoring a backup
	How to upgrade DB2 on SAP R/3 4.7
	How to create a snapshot from NAS and SAN of Oracle database
	How to clone an SAP ECC 6.0 instance

SAP Basis administration and NetWeaver administration

Managing DB2 transaction logs when upgrading to SAP ECC 6.0

Accessing SAP IDES 4.7 though SAP GUI

How to secure an SAP installation with disaster recovery

Tips on SAP file formats for electronic funds transfers

Determining if SAP user exits are separate from SAP BAPI updates

Fixing errors when implementing a user to SAP EDI system

The top SAP advice from the experts in 2009

Seven tips for simplifying SAP data archiving administration

Finding up-to-date SAP ABAP code in SAP ECC 6.0

Migrating SAP Solution Manager system between Unix platforms

SAP Basis administration and NetWeaver administration Research

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

Basis (SearchSAP.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

NetWeaver SAP White Papers

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2000 - 2010, TechTarget \| Read our Privacy Policy SearchSAP.com is a search service provided by TechTarget and is completely independent of and not affiliated with SAP AG.