Check Table Size in Oracle Database

[Former Member]

hi SAP Expert,

is there anyway i can check the table size for oracle database? thanks.

Regards

Hariyono

[Former Member · Accepted solution]

Hi,

If your requirement is about checking the size of a particular table then use the program RSTABLESIZE. Execute using the Tcode SE38

Regards,

Sharath

[Former Member · Accepted solution]

hi Sharath,

program RSTABLESIZE is only can list out one table at the time, is there any report can list a several table size at the same time? thanks.

[Former Member · Accepted solution]

Hi,

if you have the access to the DB02 transaction you can chek in DB02 - segment management.

Also you can check it using BRTOOLS from the OS level.

Thanks,

Chaitanya.

[JPReyes · Accepted solution]

DB02 -> Detailed analysis -> enter the name of the table.

It should give you the details of the table including size, blocks, segments/

Regards

Juan

[Former Member · Accepted solution]

Hi,

What you can do is instead of giving a sinlge table give * (or in similar fashion like Z, U etc) where it will display the size of all the tables in that client. But this might take some time to execute. Just try this if this meets your requirement.

Regards,

Sharath

[Former Member · Accepted solution]

You can check it at os level using brtools if your operating system is UNIX or AIX.

Steps are below - Login as orasid user and execute command brtools

Segment management -- Additional segment functions -- Show tables -- Database table (Provide table name over here)

And Press Continue for couple of times. It will give you desired output.

Thanks and Regards,

Kedar