cancel
Showing results for 
Search instead for 
Did you mean: 

Next extents for database loads Should I cange default?

Former Member
0 Kudos

Should I increase the next extent of a table like VBAK from the sap default to something higher.

Will I gain any performance if I change initial/next extent that is set for 16 up to say 10,000 if I am loaded 3 million sales orders?

Thanks much folks

Mikie

Accepted Solutions (1)

Accepted Solutions (1)

former_member204746
Active Contributor
0 Kudos

Mikie, let SAP do the work for you.

run this command daily:

brconnect -c -u / -f next

Answers (2)

Answers (2)

lbreddemann
Active Contributor
0 Kudos

Hi Mikie,

in the medium run distance you should consider changing the tablespace over to locally managed mode. With this you don't have to bother with NEXT extent sizes ever again.

Moreover lmts tablespaces eliminate a possible performance bottleneck: the access to the dictionary tables to maintain free space in the tablespaces.

KR Lars

Former Member
0 Kudos

Hello Mikie,

Increasing the extents can help you have a bit of good performance but the risks associated with it are also high.If you are short of table space you can add it when required but when you run out of extents on tables then it might have a tough time for you.

So better to keep the extents to what they are set to.

The link below should be helpful for you to decide how to act on the issue

http://help.sap.com/saphelp_nw04s/helpdata/en/d1/a9fe384b8a11d189510000e829fbbd/content.htm

**Reward points accordingly

Junaid