topic Re: DATA BASE TABLES in Application Development and Automation Discussions

DATA BASE TABLES

Former Member — Wed, 05 Jul 2006 10:28:02 GMT

Hi All,

I Have some records (say 10,000) in my Data Base table.

I need to find How much size that table occupies in the database.

ALL The Best,

Mahesh.

Re: DATA BASE TABLES

Former Member — Wed, 05 Jul 2006 10:30:33 GMT

Checkout the FM`S in SE37

/BKC/RFC_GET_TABLE_SIZE

/SDF/INF_TOP_TABLES

/SDF/MSS_TEXT_IMAGE_FIELDS

GET_TABLE_SIZE_DB4

GET_TABLE_SIZE_DB6

MSS_GET_DB_SIZE_DETAILS

MSS_GET_SCHEMA_SIZE_INFO

MSS_GET_TABLE_SIZE_INFO

SFMSS_SIZE

GET_TABLE_SIZE_MSS

Pl also award the points .

Re: DATA BASE TABLES

Former Member — Wed, 05 Jul 2006 10:32:19 GMT

Go to SE11. Enter the table name and Choose Display.

Go to Utilities -> Runtime Object -> Display

Under Header of active runtime object the fourth column i.e Table length gives you the maximum size of a single record of the table.

Note this is the maximumsize and not the actual size a record would occupy in the database.

-Kiran

*Please reward useful answers

Re: DATA BASE TABLES

Former Member — Wed, 05 Jul 2006 10:36:38 GMT

Hai Mahesh

Check the following F.M

GET_TABLE_SIZE_INFO_DB2

GET_TABLE_SIZE_DB2

GET_TABLE_SIZE_DB4

GET_TABLE_SIZE_ADA

GET_TABLE_SIZE_INF

GET_TABLE_SIZE_DB6

GET_TABLE_SIZE_MSS

GET_TABLE_SIZE_ORA

GET_TABLESIZE_ORA_OLD

GET_TABLE_SIZE_ALL

Thanks & regards

Sreenivasulu P

Message was edited by: Sreenivasulu Ponnadi

Re: DATA BASE TABLES

Former Member — Wed, 05 Jul 2006 10:42:22 GMT

Hi Mahesh,

U can use this FM : DB_GET_TABLE_SIZE which will give u the size in KB.

If it helps, please do reward.