This Site Create for Help Tech guys in Issues and fixes in Linux SAP and Oracle.

Search This Blog

Powered by Blogger.

Create Client in SAP

First Create Client via SCC4 THEN COPY Client via SCCL profile SAP_CUST After copy login into Client 000 and export default users t...

Pull Oracle Tablespace Size


select owner, table_name, round((num_rows*avg_row_len)/1024) "Size in KB" from All_tables where owner = 'SAPR3' order by "Size in KB" desc;


SELECT DS.TABLESPACE_NAME, SEGMENT_NAME, ROUND(SUM(DS.BYTES) / 1024) "SIZE in KB"
  FROM DBA_SEGMENTS DS
  WHERE SEGMENT_NAME IN (SELECT TABLE_NAME FROM ALL_TABLES where OWNER='SAPR3')
 GROUP BY DS.TABLESPACE_NAME,
       SEGMENT_NAME;


0 comments:

Post a Comment