达梦运维常用的sql及视图表:
– 查看数据库版本
select * from v$version;
–查看小版本信息:
select id_code();
–查看授权信息
select * from v$license;
–查看服务器信息
select * from V$SYSTEMINFO;
–查询会话连接信息
select * from v$sessions;
select count(*),state from v$sessions group by state;
select count(*),clnt_ip from v$sessions group by clnt_ip;
–查询数据库服务器配置参数
select * from v$dm_ini;
–查询最近的sql执行记录
select * from v$sql_history;
–查询某个用户下所有的表
select table_name from user_tables ; --查询当前用户下的所有表;
select * from all_tables where owner=‘TEST’; --dba用户查询某个用户下的所有表;
–查询某个用户下的所有表字段
select * from all_tab_cols where owner=‘TEST’;
–查看表注释
select * from ALL_TAB_COMMENTS where owner=‘TEST’;
–查看字段注释
select * from ALL_COL_COMMENTS where owner=‘TEST’;