达梦SQL

达梦SQL语句

实例中总数据量：

with a as(
select table_rowcount(owner,table_name) 行数,
table_used_space(owner,table_name)/1024.0/1024*page 大小mb,
* from dba_tables order by 大小mb desc
)select sum(行数),sum(大小mb) from a;

实例所有表的数据量：

select table_rowcount(owner,table_name) 行数,
table_used_space(owner,table_name)/1024.0/1024*page 大小mb,
* from dba_tables order by 大小mb desc;

删除数据：

delete FROM wxqyh.tb_qy_flow_node_todo_ref WHERE ref_id = 'work5ce3572bd2fd4ca5993e8b6f3831bf5d'  AND current_node_id = 'f3fb0c7f-d560-48ae-8681-a5e37ded55cb';

只读用户：

create user "monitor" identified by "Szy@dm@123" read only;
create user "MONITOR" identified by "Szy@dm@123" read only;

grant "SOI","SVI","VTI" to "MONITOR";

grant SELECT ANY DICTIONARY to "MONITOR";

select * from do1cloud_common_portal.tb_department_info where dept_full_name ='市辖区';


delete from do1cloud_common_portal.tb_department_info where dept_full_name='test6666';


select * from "do1cloud_common_portal"."tb_qy_user_info" limit 10;

select * from do1cloud_common_portal.tb_department_info where dept_full_name ='单位领导';

select * from "do1cloud_common_portal"."tb_qy_user_info" where PINYIN='lijiqiang';

SELECT COUNT(DISTINCT wx_user_id) FROM do1cloud_common_portal.tb_qy_user_info;

SELECT COUNT(DISTINCT wx_user_id) FROM do1cloud_common_portal.tb_department_info;

SELECT COUNT(DISTINCT wx_user_id) FROM do1cloud_common_portal.tb_qy_user_department_ref;

1.关闭监视器：       --(自动切换才有监视器，手工切换可忽略)
2.关闭主机的守护进程 ： DmWatcherServiceDM stop 
3.关闭备机的守护进程：  DmWatcherServiceDM stop
4.关闭主机实例： DmServiceDM stop
5.关闭备机实例： DmServiceDM stop


1.启动主库数据库：DmServiceDM   start
2.启动备库数据库：DmServiceDM start
3.启动主库守护进程： DmWatcherServiceDM start
4.启动备库守护进程：t DmWatcherServiceDM start
5.启动监视器：DmMonitorDM  --(自动切换才有监视器，手工切换不需要)