db2 -x "select substr(tbsp_name,1,20) as TABLESPACE_NAME,substr(tbsp_content_type,1,10) as TABLESPACE_TYPE,sum(tbsp_total_size_kb)/1024 as TOTAL_MB,sum(tbsp_used_size_kb)/1024 as USED_MB,sum(tbsp_free_size_kb)/1024 as FREE_MB,tbsp_page_size AS PAGE_SIZE from SYSIBMADM.TBSP_UTILIZATION group by tbsp_name,tbsp_content_type,tbsp_page_size order by 1"
TABLESPACE_NAME      TABLESPACE_TYPE TOTAL_MB             USED_MB              FREE_MB              PAGE_SIZE  
-------------------- --------------- -------------------- -------------------- -------------------- -----------
SYSCATSPACE          ANY                              128                  111                   16        4096
SYSTOOLSPACE         LARGE                             32                    0                   31        4096
TEMPSPACE1           SYSTEMP                            0                    0                    0        4096
USERSPACE1           LARGE                            384                  371                   12        4096

  4 record(s) selected.


版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle