How much space it is occupying for each Material Master in MARA table.

[Former Member]

Hi Gurus & Markus .

If one of the functional consultant creates a Material Master in MARA how much space it will occupy for each. Like we need to create 10000 material masters.

How can i access exactly to that table in terms of db growth.

-

---

>Rahul

[former_member204746 · Accepted solution]

use this command:

select blocks from dba_tables where table_name='MARA';

then add 8 entries. then same command:

select blocks from dba_tables where table_name='MARA';

check difference between the 2, you will get a small number, you will get the number of Kbytes used per record.

[fidel_vales · Accepted solution]

Hi Eric,

Easier, if statistics are current

select avg_row_len from dba_tables where table_name='MARA';

as per oracle docu:

Average length of a row in the table (in bytes)

remark-> accuracy depends on stats

[former_member204746 · Accepted solution]

nice trick, Fidel!

by the way, my earlier response is defined with 8K blocks which is common on SAP systems.

[Former Member]

you can check current usages from DB02 --> detailed analysis --> give the object name MARA and you will see the result.

check how many entries are there in MARA table via se16 --> mara --> number of entires. i think now its easy you to calculate as per your requirement.

cheers,

-Sunil