Check Table Size in Oracle Database

[Former Member]

Hi all!

I was faced with a simple task.

How to determine the size of the table? Using reports RSSPACECHECK and RSTABLESIZE to note (118823 - CC-ADMIN: Size of a client) and data from DB02 I get different sizes talitsy. For example, table MARC.

1) DB02:

SAPSR3 MARC TABLE PSAPSR3, Size: 70 440,000 (MB)

2) From RSTABLESIZE:

  2 469.66 kbyte

Whom to believe?

[Former Member · Accepted solution]

hi,

For specific table in RSSPACECHECK.

1. Specify client in which tables resides otherwise substitute with * for table size including all clients.

2. Specify table name

3. Class A and L substitute with *  value and execute.

Please note rsspace check as per note 118823 - CC-ADMIN: Size of a client is made for CLIENT sizes!

As reagan stated best is to query from DB level, but you did not specify you DB type.

If it is oracle refer to link https://community.oracle.com/message/10199090

Kind Regards,

Johan

[Former Member]

Friends, you disappoint me with your answers 

[Former Member]

What was the cause of disappointment...

Thanks

Rishi Abrol

[Former Member]

Because I have not received the exact answer.

[Reagan]

Hello

Just rely on the information from the Tx DB02.

If you do a quick search for the report RSTABLESIZE you will find similar issues discussed before.

I would query from the SQL level to confirm whether DB02 is correct as well 😉

select bytes, segment_name from dba_segments where segment_name = 'MARC';

Additionally you can use BRTools

Regards

RB

[Former Member]

Hi,

Can Check the table size in Db02 or at SQL level.

Below is one of the blog that will also help you.

http://scn.sap.com/message/5954410#5954410

What is the release of the system as it looks that the note had old sap releases.

Thanks

Rishi Abrol