Table size and growth

[former_member954801]

Hi,

We need to get the Current table size and the growth of the table in SAP.

i belive we get the same by BR tools, but we do not have access to BR tools is there any other way from SAP.

Thanks

Chiru

[Former Member]

Padmanabhan,

If you using SAP NW2004 system then you need to use DB02.If you are using SAP NW2004s system you need use tcode DB02OLD. Then select Detail analysis button--> Give Object type as *,

Tablespace *, objetc type table *.

This will read from dba_segment & it will give list of all table & table partitions(if any)

.

Also Incase if you are planning to reduce the DB size then check below link. It will help you out.

Hope this helps

Thanks

Sushil

Edited by: Sushil Suryawanshi on Jun 2, 2009 9:13 PM

[anindya_bose]

Use DB02 or DB02 old>> Space Statistics ..you will get the space used by a particular tablespace

you can get the tablespace history from that screen only

for size of a particular table , choose "Detail Analysis" in Tables and Indexes part in DB02.