操作 神通数据库_神通数据库命令行

1.--查询表空间使用情况

SELECT T.TSNAME AS TSNAME,

D.PATH,

COUNT(*) "File Count",

SUM(D.SIZE) / 1048576 AS "Size(MB)",

SUM(D.FREESIZE) / 1048576 AS "Free Size(MB)",

(SUM(D.SIZE) - SUM(D.FREESIZE)) / 1048576 AS "Used Size(MB)"

FROM SYS_TABLESPACE T

LEFT JOIN V_SYS_DATAFILE_INFO D

ON T.TSID = D.TABLESPACEID

GROUP BY T.TSNAME,D.PATH;

2.--查询各节点表空间使用情况

execute direct on all 'SELECT T.TSNAME AS Schema, SUM(D.SIZE) / 1048576 AS "Size(MB)", SUM(D.FREESIZE) / 1048576 AS "Free Size(MB)", (SUM(D.SIZE) - SUM(D.FREESIZE)) / 1048576 AS "Used Size(MB)" FROM SYS_TABLESPACE T,V_SYS_DATAFILE_INFO D where T.TSID = D.TABLESPACEID and T.TSNAME=''STLTS'' GROUP BY T.TSNAME';

3.--查询数据文件使用情况

SELECT T.TSNAME as "NAME",

PATH,

"CREATIONTIME" as "Creation Time",

"NEXTSIZE" / 1048576 as "Next Size(MB)",

"MAXSIZE" / 1048576 AS "Max Size(MB)",

"SIZE" / 1048576 AS "Size(MB)",

FREESIZE / 1048576 AS "Free Size(MB)",

("SIZE" - FREESIZE) / 1048576 AS "Used Size(MB)",

("SIZE" - FREESIZE) * 100.0 / SIZE AS "Used RATIO"

FROM V_SYS_DATAFILE_INFO, SYS_TABL