selectcount(*),state from v$sessions groupby state; selectcount(*),clnt_ip from v$sessions groupby clnt_ip;
--查看数据库服务器配置参数 select * from v$dm_ini;
--查询最近的 SQL 执行记录 select * from v$sql_history;
--查询某个用户下所有的表 select * 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 ower=’TEST’;
--查看字段注释 select * from ALL_COL_COMMENTS where ower=’TEST’;
select'实例名称' 数据库选项,INSTANCE_NAME 数据库集群相关参数值 FROM v$instanceunionall
select'数据库版本',substr(svr_version,instr(svr_version,'(')) FROM v$instanceunionallSELECT'字符集',CASE SF_GET_UNICODE_FLAG() WHEN'0'THEN'GBK18030'WHEN'1'then'UTF-8'when'2'then'EUC-KR'endunionall