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: 

Table Size

former_member1326872
Participant
0 Kudos
872

Hi,

Can someone tell me whether I can check the size of a table through SE11? Or is it only posssible to check by the Basis people?

If we can get the size of the table through SE11 itself, please let me know how can I do that?

Thanks

Swetha

7 REPLIES 7

Former Member
0 Kudos
338

Hi Swetha,

If you are authorized to see DB02 txcode you can see your table size by yourself.

As it is highly important txcode mostly nobody will be authorized to see expect Basis guys.

With SE11 in technical settings you can only estimate by giving the size. But exact memory how can you point out i have no idea with SE11.

Cheers!!

Venkat

Edited by: Venkat Reddy on Oct 24, 2008 12:46 AM

Edited by: Venkat Reddy on Oct 24, 2008 12:49 AM

0 Kudos
338

Hi Venkat,

Thanks for the info. This transaction is giving the overall information on the Database. Could you please tell me how do I check the size of a particular table that I am interested in?

Thanks a lot..

Swetha

0 Kudos
338

Hi Swetha,

Follow the navigation DB02->click on Detailed Analysis push button->opens small pop up ->give your Table name in Object name text box->and press enter dont bother of *s in tablespace and object type.

You will get a details memory management.

Still any issues revert me back soon.

Cheers!!

Venkat

0 Kudos
338

you can use the function module DB_GET_TABLE_SIZE , for this pass the table name and find its size.

Former Member
0 Kudos
338

yes...u can do that if u have authorizations.

press techical settings button is SE11 after entreing a table name and u can mention ur required size of the table.

Thanks

Kiran

Former Member
0 Kudos
338

Hi Swetha,

Have you got it ? Even you can get much more in this transaction spend sometime you will get good knowledge.

Cheers!!

Venkat

0 Kudos
338

Hi Venkat,

Sorry for the delay. Thanks a lot for the additional help. I am able to see the Detailed analysis of the table I am interested in. But I am not able to clearly understand the result that it gives. It gives data like below:

Allocated space..Kbyte 865,960

blocks...... 108,245

extents..... 131

*Used blocks.......... 104,304

*Never used blocks.... 5,211

*Free in used blocks.% 14

*Total free space....% 18

Could you please provide me some understanding on what exactly is the size the table is occupying or how big is the table now.

Thanks again..

Swetha