topic Re: Table Size in Application Development and Automation Discussions

Table Size

Former Member — Thu, 23 Oct 2008 19:12:53 GMT

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

Re: Table Size

Former Member — Thu, 23 Oct 2008 19:15:49 GMT

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

Re: Table Size

Former Member — Thu, 23 Oct 2008 19:17:04 GMT

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

Re: Table Size

Former Member — Thu, 23 Oct 2008 19:20:58 GMT

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

Re: Table Size

Former Member — Thu, 23 Oct 2008 19:24:36 GMT

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

Re: Table Size

Former Member — Thu, 23 Oct 2008 19:30:32 GMT

Hi Swetha,

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

Cheers!!

Venkat

Re: Table Size

Former Member — Thu, 23 Oct 2008 19:32:29 GMT

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

Re: Table Size

Former Member — Thu, 23 Oct 2008 20:53:51 GMT

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