gbase8s之常用sql脚本
## 查看数据库锁
dbaccess sysmaster - << EOF
select username,sid,waiter,dbsname,tabname,rowidlk,keynum,type
from sysmaster:syslocks a,sysmaster:syssessions b
where b.sid=a.owner and dbsname='lucifer';
EOF
## 查看表空间使用率
dbaccess sysmaster - << EOF
SELECT st.dbsname databasename, st.tabname,
MAX(dbinfo('UTC_TO_DATETIME',sin.ti_created)) createdtime,
SUM( sin.ti_nextns ) extents,
SUM( sin.ti_nrows ) nrows,
MAX( sin.ti_nkeys ) nkeys,
MAX( sin.ti_pagesize ) pagesize,
SUM( sin.ti_nptotal ) nptotal,
round(SUM( sin.ti_nptotal*sd.pagesize )/1024/1024,2)||'MB' total_size,
SUM( sin.ti_npused ) npused,
round(SUM( sin.ti_npused*sd.pagesize )/1024/1024,2)||'MB' used_size,
SUM( sin.ti_npdata ) npdata,
round(SUM( sin.ti_npdata*sd.pagesize )/1024/1024,2)||'MB' data_size
FROM