Need to know the size of my table

[Former Member]

dear all,

I was able to figure out that there are millions of records in my table (cluster table) by writing a short program and running it in the background. But is there a way to determine the size of the table in kbs.Example: I know i have 73 million records in my table and there are 300 fields, is there a way to ascertain the size of the table in KBs. DB02 doesnt show this information for cluster tables.

Please let me know if there is a way to determine that.

thank,

Krrish

[former_member181995]

Would these Help?

http://help.sap.com/saphelp_nw2004s/helpdata/en/c2/36c5067754044db2b91b00ba60b36a/content.htm

[former_member222860]

Hi,

You can use this Native Sql statement, it gives the actual table size.

DATA: BEGIN OF SIZE OCCURS 0,

KB LIKE SEGMENTS_S-KBYTES,

END OF SIZE.

EXEC SQL.

SELECT SUM(BYTES)/1024 FROM DBA_SEGMENTS WHERE

SEGMENT_NAME = :TABNAME

INTO :SIZE

ENDEXEC.

thanks

Mahesh

[Former Member]

Hello Mahesh,

I have used the program you suggested in SE38 and this is what it looks like:

DATA: BEGIN OF SIZE OCCURS 0,

KB LIKE SEGMENTS_S-KBYTES,

END OF SIZE.

EXEC SQL.

SELECT SUM(BYTES)/1024 FROM DBA_SEGMENTS WHERE

SEGMENT_NAME = :'BSEG'

INTO :SIZE

ENDEXEC.

But for some reason when i hit direct processing or execute it doesnt do a thing. Where should i see the result.

Do i need to run this in the background and if so where can i see the output, please provide me the additional codeing, if i run it in the background and need to see the output.

Thanks,

[Former Member]

Anyone ???????

[Former Member]

Hi

[https://forums.sdn.sap.com/click.jspa?searchID=19733724&messageID=6420846]

[Former Member]

Try using transaction DB02.

[former_member223537]

DATA: BEGIN OF SIZE OCCURS 0,
KB LIKE SEGMENTS_S-KBYTES,
END OF SIZE.

EXEC SQL.
SELECT SUM(BYTES)/1024 FROM DBA_SEGMENTS WHERE
SEGMENT_NAME = :'BSEG'
INTO :SIZE

ENDEXEC.

WRITE 😕 'SIZE:', SIZE.  " TO display the result

Add the above line & then execute the program.

[Former Member]

I get a message ' "SIZE" cannot be converted to a character-type field'

[former_member222860]

Hi Krrish,

If u wanted to see the size of the table, just place 'write' after the code i had given

like this:

write:/ size-kb.

Sorry, i had not seen ur reply.

If it works, pl close the thread

thanks\

Mahesh