topic Re: SIze category issue in Application Development and Automation Discussions

SIze category issue

Former Member — Wed, 15 Aug 2012 19:57:04 GMT

hai experts,

I h've one doubt.,that is if i select size category as 8 in se11, how the background process woks? like in data base layer it allocates space for 1300000

records? if this means really waste of huge memory.....is it? Suppose i want to enter 12222 records only then the remaining space is waste only. what is the actual process here???

Regards,

Ravi Kiran.

Moderator Message: Read the SAP documentation on "Size category". Thread locked.

Message was edited by: Suhas Saha

Re: SIze category issue

Former Member — Thu, 16 Aug 2012 05:47:58 GMT

Hi Ravi,

When a table is created, initial space (an Initial Extent) is reserved in the database. If more space is required at a later time due to data entries, additional memory will be added depending on the selected size category.

Selecting the correct size category prevents the creation of a large number of small extents for a table. It also prevents the waste of space if extents that are too large are created.

Thanks

Santosh