Skip to Content
Former Member
Apr 03, 2014 at 10:54 AM

SAP Table Size Query


Hi Experts,

- SAP PRD system is using SAP ECC 6.0 EHP5, with load balancing, log shipping and DB clustering.

- Servers are running Windows 2008 R2 (Enterprise) with MS SQL Server 2008 R2.

- Current DB size is 90GB.

Need some help to compose SQL query to calculcate the size of a particular table, for example: table PA0003.

Have been searching around, but could not find the right solution.

So far, this is the better example found on SCN, however, it's not working.

SELECT SUM(bytes)/1024/1024 MB

FROM user_segments

WHERE segment_type = 'TABLE'

AND segment_name = <table name>

Could anyone help out?

Thank you.

- Peter