- 查看达梦数据库最大连接数
SQL> select SF_GET_PARA_VALUE(2,'MAX_SESSIONS');
行号 SF_GET_PARA_VALUE(2,'MAX_SESSIONS')
---------- -----------------------------------
1 65000
已用时间: 1.006(毫秒). 执行号:5994100.
- 查看达梦数据库当前连接数
SQL> select count(*) from v$sessions where state='ACTIVE';
行号 COUNT(*)
---------- --------------------
1 1
- 查看达梦授权到期时间
select expired_date from v$license;
- 达梦数据库版本查看
select id_code();
select * from v$version;
select * from v$instance;
-
删所有schema
drop SCHEMA COOPPER CASCADE;
drop SCHEMA KINGSOFT_QING CASCADE;
… -
达梦数据登录命令
./disql sysdba/xxx@localhost:5236
- 查询所有schema
select distinct object_name TABLE_SCHEMA from all_objects where object_type = 'xxxx';
- 查询指定用户下的schema
select distinct object_name TABLE_SCHEMA from all_objects where object_type = 'xxx' AND OWNER='SYSDBA';
- 查询表空间
select tablespace_name from dba_tablespaces;
- 查询所有表
select TABLE_NAME from dba_tables;