Find out how much data is in a certain table

[Former Member]

Hi experts,

I have deleted a lot of entries in a certain table by running the reorganisation-reports in SAP.

Now I know that the table do not change its size because of the HWM. So new data in the table will be inserted in the freed blocks. Now I would like to know how much data remained in the table.

So e.g. the table was 100 GB the size before reorganisation. Now I have deleted a lot of entries and I would like to know, how much data remained in the table. I know that I can find out the average line size and number of entries in DB02old but this is imprecise for me.

Any idea?

[stefan_koehler]

Hi,

you can use the PL/SQL procedure DBMS_SPACE.SPACE_USAGE for that, if your tablespace is created with auto segment space management.

Documentation: http://docs.oracle.com/cd/E11882_01/appdev.112/e16760/d_space.htm#CACBDJIH

Regards

Stefan