达梦数据库基本操作

查询所有schema

select distinct object_name TABLE_SCHEMA from all_objects where object_type='SCH';

 查询指定用户下的schema

select distinct object_name TABLE_SCHEMA from all_objects where object_type='SCH' AND OWNER='SYSDBA';

 查询表空间

 select tablespace_name from dba_tablespaces;

 查询所有表

select TABLE_NAME from dba_tables;

查询表空间

select tablespace_name from dba_tablespaces;

 查询连接次数

select para_name,para_value from v$dm_ini where para_name='MVCC_RETRY_TIMES';