加载中…teradata 中查看系统空间容量的几个视图
(2011-07-15 14:07:43)
标签：
杂谈 |
select * from dbc.diskspace
where databasename='dwmart_ecr';
select sum(maxperm),sum(currentperm),sum(maxspool),sum(currentspool),sum(maxtemp),sum(currenttemp) from dbc.diskspace
where databasename='dwmart_ecr';
select * from dbc.tablesize
where tablename like '%M_0646_BJSHD_S%'
select sum(currentPerm),sum(Peakperm) from dbc.tablesize
where tablename like '%M_0646_BJSHD_S%'
select sum(currentPerm),sum(Peakperm) from
dbc.allspace
where tablename like '%M_0646_BJSHD_S%'
where databasename='dwmart_ecr';
select sum(maxperm),sum(currentperm),sum(maxspool),sum(currentspool),sum(maxtemp),sum(currenttemp) from dbc.diskspace
where databasename='dwmart_ecr';
select * from dbc.tablesize
where tablename like '%M_0646_BJSHD_S%'
select sum(currentPerm),sum(Peakperm) from dbc.tablesize
where tablename like '%M_0646_BJSHD_S%'
select sum(currentPerm),sum(Peakperm)
where tablename like '%M_0646_BJSHD_S%'
喜欢
0
赠金笔
前一篇：统计行数