Altibase 4.3.9.11 버젼 테이블 스페이스 정보보기

알티베이스 버젼
version 4.3.9.11 IBM_AIX_5.3-64bit-4.3.9.11-release-xlC_r (powerpc-ibm-aix5.3.0.0) Sep 12 2006 20:39:18, binary db version 4.11.1, meta version 4.8.1, cm protocol version 4.5.1, replication protocol version 4.7.1

set linesize 1000;
set colsize 20;
 
SELECT
         UF.NAME SPACENAME,
         ROUND(DF.MAXSIZE, 3)||' MB' MAXSIZE ,
         ROUND(DF.CURRSIZE, 3)||' MB' CURRSIZE ,
         NVL(to_char(ROUND(UF.USED_PAGE_CNT*8/1024,3)),'N/A')||' MB' USEDSIZE
     FROM
         (SELECT
             SUM(MAXSIZE)*8/1024 MAXSIZE ,
             SUM(CURRSIZE)*8/1024 CURRSIZE ,
             SPACEID
         FROM
             V$DATAFILES
         GROUP BY SPACEID) DF , V$TABLESPACES UF
     where DF.SPACEID = UF.ID
     UNION ALL
     SELECT
         'SYS_TBS_MEMORY' SPACENAME,
         ROUND(MEM_MAX_DB_SIZE/1024/1024,3)||' MB' MAXSIZE,
         ROUND(MEM_ALLOC_PAGE_COUNT*32/1024,3)||' MB' CURRSIZE,
         TO_CHAR(ROUND(MEM_ALLOC_PAGE_COUNT*32/1024,3))||' MB' USEDSIZE
     FROM
         V$DATABASE
     ORDER BY 1;