topic Memory Space Occupied by Each Table in Application Development and Automation Discussions

Memory Space Occupied by Each Table

Former Member — Thu, 14 Dec 2006 08:52:33 GMT

Hi Experts,

I need a transaction or a table or any location where i can find the memory space occupied by each of the tables(eg. Mem Space Occupoed by VBAP with the tablespace and Functional Area allocated to it) preferrably with their functional areas and tablespaces.

Expecting quick replies as i have very urgent requirment.

Thanks to all for the same.

Best Regards,

Aravind

Re: Memory Space Occupied by Each Table

Former Member — Fri, 15 Dec 2006 16:01:56 GMT

Hi Aravind

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).

Hope this gets you started.

Points Appreciated!

Robin

Re: Memory Space Occupied by Each Table

Sandeep_Panghal — Wed, 20 Dec 2006 11:49:19 GMT

Hi Aravind,

Use Transaction <b>DB6SPACE</b> - it gives the table space and also u can anlyze the many more things.

Hope this helps.

Re: Memory Space Occupied by Each Table

Former Member — Fri, 05 Jan 2007 05:26:51 GMT

The question has not been answered ....

Re: Memory Space Occupied by Each Table

Former Member — Fri, 05 Jan 2007 05:29:10 GMT

Generally its transaction DB02 that gives the sapce stats of tables a swell.

DB02 --> Tables ( Space Statistics) --> OK --> Shd give the space occupied by tables and their tablespaces..

A sort is possible as well.,.,..

kishan negi

Re: Memory Space Occupied by Each Table

VinayPrasad_PM — Mon, 08 Jan 2007 13:56:36 GMT

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