ORACLE 锁表对象 | 锁表进程 | 字符集 | 版本号 |默认表空间

1. 查询当前用户锁表对象
select sess.sid,
    sess.serial#,
    lo.oracle_username,
    lo.os_user_name,
    ao.object_name,
    lo.locked_mode
    from v$locked_object lo,
    dba_objects ao,
    v$session sess
where ao.object_id = lo.object_id and lo.session_id = sess.sid; 

2.  kill锁表进程
--alter system kill session '135,44035';

3.  查字符集
select userenv('language') from dual;

4.  查版本号
select * from v$version;

5.  查看oracle用户默认表空间
select username,default_tablespace,temporary_tablespace
from dba_users
where username = 'AML';

6.   添加字段和备注
ALTER TABLE t5k_cust_rslt  ADD list_code varchar2(100);
COMMENT ON column t5k_cust_rslt.list_code IS '制裁名单';