How to check Tablespace size for SAP systems

Solution -1: Check from SAP front end:

Execute T-code DB02.

Select Space ->Tablespaces ->Overview

    

For getting the updated details make sure that the SAP Job SAP_COLLECTOR_FOR_PERFMONITOR is scheduled in your system

Solution-2: Check from SAP front end using query:

Execute DB02

Select Performance ->Additional Functions ->SQL Command Editor.

Paste the query in the input Query Field ,Load the query and Execute

You can also save the query for future use

Query :

SELECT A.TABLESPACE_NAME, A.STATUS,

ROUND(C.SIZE_GB/1024/1024,2) SIZE_MB,

ROUND((C.SIZE_GB-B.FREE_GB)/1024/1024,2) USAGE_MB,

ROUND(B.FREE_GB/1024/1024,2) FREE_MB,

ROUND(100*(1-(FREE_GB/SIZE_GB)),2) PCT_USAGE,

ROUND(C.SIZE_GB/1024/1024/1024,2) SIZE_GB,

ROUND((C.SIZE_GB-B.FREE_GB)/1024/1024/1024,2) USAGE_GB,

ROUND(B.FREE_GB/1024/1024/1024,2) FREE_GB

FROM (SELECT TABLESPACE_NAME, STATUS FROM DBA_TABLESPACES) A,

(SELECT tablespace_name,

SUM(BYTES) FREE_GB

FROM DBA_FREE_SPACE

GROUP BY tablespace_name)B,

(SELECT TABLESPACE_NAME, SUM(BYTES) SIZE_GB

FROM dba_data_files

GROUP BY tablespace_name) C

WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME

AND A.TABLESPACE_NAME = C.TABLESPACE_NAME

ORDER BY TABLESPACE_NAME;

Solution 3: Using BRTOOLS

Use BRTOOLS to find the tablesapce size 

Hope this helps!!!

Abraham