查询达梦监控服务器数据库各表大小（清理）

1、数据库监控DEM
服务目录：/data/dem/bin/DmServiceDEM
/data/dem/bin
./disql SYSDBA/SYSDBA:5236（默认）
在apache的bin目录下，通过sh start.sh启动dem查询DEM下各表大小，对占用空间最大的表DMA_DATABASE_LOCK进行清理

WITH FUNCTION GET_SIZE_BY_PAGES(NUM_OF_PAGE BIGINT, KB_MB_GB VARCHAR(2) DEFAULT 'KB') RETURN NUMBER(15, 2) AS
    V_SIZE_KB NUMBER(15, 2) := ROUND(PAGE() * NUM_OF_PAGE / 1024.00, 2);
BEGIN
    IF KB_MB_GB = 'MB' THEN
        RETURN V_SIZE_KB / 1024.00;
    ELSIF KB_MB_GB = 'GB' THEN
        RETURN V_SIZE_KB / 1024.00 / 1024.00;
    END IF;
    RETURN V_SIZE_KB;
END;
SELECT 
       T.OWNER,
       T.TABLE_NAME,
       GET_SIZE_BY_PAGES(INDEX_USED_PAGES(T.OWNER, T.INDEX_NAME), 'MB') AS TABLE_USED_SPACE_MB,
       GET_SIZE_BY_PAGES(INDEX_USED_PAGES(T.OWNER, T.INDEX_NAME), 'GB') AS TABLE_USED_SPACE_GB,
       TABLE_ROWCOUNT(T.OWNER, T.TABLE_NAME)                            AS TABLE_ROWCOUNT
FROM DBA_INDEXES T
WHERE T.OWNER IN ('DEM') AND T.INDEX_TYPE='CLUSTER' and t.TABLE_NAME in (select table_name from dba_tables where owner='DEM')
ORDER BY TABLE_USED_SPACE_MB DESC, TABLE_ROWCOUNT DESC;

--DEM.DMA_DATABASE_LOCK表最大，对其进行清理
truncate table DEM.DMA_DATABASE_LOCK

2、定时删除apache的log日志

find /data/apache-tomcat/logs -mtime +62 -type f -name *.txt -exec rm -rf {} \;