达梦数据库常用命令

创建数据库和用户

create tablespace TBS_SAAS_AGRIWE datafile '/data/dmdata/DAMENG/TBS_SAAS_AGRIWE.DBF' SIZE 1024 AUTOEXTEND ON NEXT 1024;
CREATE USER "SAAS_AGRIWE" IDENTIFIED BY "Wesj#274Lo" DEFAULT TABLESPACE "TBS_SAAS_AGRIWE" DEFAULT INDEX TABLESPACE "TBS_SAAS_AGRIWE";
GRANT "PUBLIC","RESOURCE","VTI" TO "SAAS_AGRIWE";

查看慢SQL

select DATEDIFF(ss,last_send_time,SYSDATE) a,
       sf_get_session_sql(sess_id),
       sess_id,
       sess_seq,
       sql_text,
       state,
       seq_no,
       user_name,
       trx_id,
       create_time,
       clnt_ip
   from SYS."V$SESSIONS" where state='ACTIVE' and sess_id!=sessid order by a desc ;

设置数据库最大会话连接数

sp_set_para_value(2,'MAX_SESSIONS',3000);   #值不要设置得太大，设置后需要重启数据库

查看最大会话数
SELECT COUNT(*) AS active_sessions FROM v$sessions