on 04-30-2007 5:11 PM
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
Mikie, let SAP do the work for you.
run this command daily:
brconnect -c -u / -f next
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.