max extent

[Former Member]

hi all,

what is max extent?? what is it use for?

How to increase max extent through sapgui and through sapdba?

regards

vijay

[Former Member · Accepted solution]

Hi,

Compare the values with the values in your init<SID>.ora file and adjust if necessary

We have archivelog turned on in our DEV system, and generally you would want

archivelog mode turned on in all of your systems. The archive files in our

DEV system grow very slowly compared to our PRD system.

As for you control_file parameter, you only need the 3 copies but you could

make more if you were worried about it. Just make sure that the path to the

control files is defined in the parameter 'control_files' in you

init<sid>.ora file. As for the error you are getting about the control file

parameter, double check that the files listed in the 'control_files' parm

actually exist where the parm says they exist at.

It's fine to increase the MAX EXTENT, but I would also increase NEXT EXTENT to prevent the rapid increase in number of extents. If you perform a reorganization on the table, the number of extents will be reset to zero (or maybe 1).

You can take a look at the history of the table growth and how fast the number of extents are increasing through tcode DB02. If the number of extents is rapidly increasing for a table, increase NEXT EXTENT to a larger value of KB.

A.V

[Former Member]

Hi Vijay,

You can use BRCONNECT to adapt the next extents size. The aim is to avoid the structure of tablespaces deteriorating – that is, breaking up into a large number of small extents – because this reduces database performance.

Recommendation

We strongly recommend you to use this BRCONNECT function rather than the equivalent SAPDBA one, sapdba -next <tablespace(s)>. The reason is that we will in future no longer develop the SAPDBA functions, whereas BRCONNECT functions will always be fully up-to-date.

You can follow bellow link for more information <a href="http://help.sap.com/saphelp_47x200/helpdata/en/1f/1cbbf5e3c3c14c82169366f1b6f629/frameset.htm">http://help.sap.com/saphelp_47x200/helpdata/en/1f/1cbbf5e3c3c14c82169366f1b6f629/frameset.htm</a>

Refer to the Note 666061 - FAQ: Database objects, segments and extents

Regards,

Suraj

.

[Former Member]

Max extent is the maximum no. of extents that can be used for a particular object.

In SAPDBA,

d - Reorganisation

b - Alter/Show Table or Index Parameters

b - Table or Index -> Provide Name of the object

s - Alter/Show Parameters

C- Max Extent ( Confirm this once in sapdba)

S - commit

Reward points if useful