![Oracle常用命令 Oracle常用命令](https://image.shishitao.com:8440/aHR0cHM6Ly9ia3FzaW1nLmlrYWZhbi5jb20vdXBsb2FkL2NoYXRncHQtcy5wbmc%2FIQ%3D%3D.png?!?w=700&webp=1)
查看数据库锁的情况
SELECT object_name, machine, s.sid, s.serial#
FROM gv$locked_object l, dba_objects o, gv$session s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid;
关闭一个session
ALTER system kill session '305, 48290';
看一下数据库用的字符集
select * from nls_database_parameters;
获取某个table的列注释
select * from user_col_comments where table_name='ARTI_ARTICLE';
看一下用户用的字符集
select userenv('language') from dual;