————————————————————————————————————————————————————————————
一、系统
– 查询license有效期
select GET_LICENSE_VALIDDAYS();
– 修改字符编码
alter table 模式名称.表名称 CHARACTER SET utf8 COLLATE utf8_general_ci
– 查看数据库
select * from sys_database
– 查看表空间
select * from sys_tablespace
– 查看语言
select * from sys_language
– 查看角色用户
select * from sys_user
– 查看会话进程
select * from sys_stat_activity
– 查看当前账号会话数
select count(*), usename from sys_stat_activity group by usename