‎2006 Dec 15 5:44 AM
Hi Experts,
I want to find out the memory space alocated to each and every table along wit the table space and its functional area(For example the memory used by vbak and its functional area and the table space associated with it) is there any table or any location in SAP which contains these information.
It will be really helpful for me.
Expecting quick replies.
Thanks in Advance.
With Best Regards,
Venkat.
‎2006 Dec 15 1:01 PM
Hi
you can find these details in Technical details of the table.
SE11 -> TECHNICAL SETTINGS
‎2006 Dec 15 3:06 PM
Hi,
You can find table space information by using space analysis transaction DB6SPACE.
There you click on Space-->single table analysis and in the right hand side you can enter the table name in the text box "Name" to find out table space and total table size.
To find out the functional area to which this table belongs go to transaction SE11>Attributes>go to package and here you can see to which software component your table belongs to.
Best regards,
Vinay
‎2006 Dec 21 5:45 AM
hi,
DB02 - Database Performance Tables and Indexes gives you access to the information you require.
If you don't have access to that, the Database Utility (accessed directly via SE14) shows many of the settings and the usage percentages under Storage Parameters.
Just be careful you don't update anything! (unless you want to).
Use Transaction DB6SPACE - it gives the table space and also u can anlyze the many more things
Regards,
Sourabh