Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

DATA BASE TABLES

Former Member
0 Kudos

Hi All,

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

I need to find <b><u>How much size that table occupies in the database.</u></b>

ALL The Best,

Mahesh.

4 REPLIES 4

Former Member
0 Kudos

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 .

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Mahesh,

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

If it helps, please do reward.