常用SQL

–查看锁表

select b.owner TABLEOWNER,b.object_name TABLENAME,c.OSUSER LOCKBY,c.USERNAME LOGINID, c.sid SID, c.SERIAL# SERIAL from v$locked_object a,dba_objects b,v$session c where b.object_id = a.object_id AND a.SESSION_ID =c.sid

–解锁表
alter system kill session 'SID, SERIAL'; --通过SID, SERIAL解锁
–查询数据库编码及中文占据字符

select userenv('language') from dual;
SELECT LENGTHB('你') FROM DUAL;

–当前

select count(*) from v$process;

–系统设置最大连接数

select value from v$parameter where name = 'processes';

–查看dblink

select * from dba_db_links

–创建dblink

create PUBLIC database link DZZZK_QX connect to NETOBDC identified by "1" using '172.18.3.000:1521/bdc5';

–删除dblink

DROP PUBLIC DATABASE LINK MISA239;