查看数据库锁的情况
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;
Oracle常用命令
原文：http://www.cnblogs.com/wade-luffy/p/6103952.html
