与锁表相关的表
SELECT * FROM v$lock;
SELECT * FROM v$sqlarea;
SELECT * FROM v$session;
SELECT * FROM v$process ;
SELECT * FROM v$locked_object;
SELECT * FROM all_objects;
SELECT * FROM v$session_wait;
如果出现找不到表,说明权限不足。
1.
查看被锁的表与被锁等级
select b.owner,b.object_name,l.session_id,l.locked_mode
from v$locked_object l, dba_objects b
where b.object_id=l.object_id
查看被锁表的sid,serial#
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$locked_object t1,v$session t2
where t1.session_id=t2.sid order by t2.logon_time
2.
SELECT/*+ rule */
s.username,
l.type,
o.owner,
o.object_name,
o.object_type,
s.sid,
s.serial#
FROM gv$session s, gv$lock l, dba_objects o
WHERE l.sid = s.sid
AND l.id1 = o.object_id
释放锁
alter system kill session '1050,20561';
增加字段
ALTER TABLE TBL_RM_100110_11 ADD VLAN_DESCRIPTION VARCHAR(100)
增加主键
alter table TBL_RM_100110_11 add constraint pk_100110 primary key(DATASOURCE_ID,SLOTID)
删除主键
alter table TBL_RM_100110_11 drop primary key;
一、查询索引
1. 根据表名,查询一张表的索引
select * from all_indexes where table_name=upper('表名');
2. 根据索引号,查询表索引字段
select * from all_ind_columns where index_name=('索引名');
3.根据索引名,查询创建索引的语句
select dbms_metadata.get_ddl('INDEX','索引名', '用户名') from dual ; --'用户名'可省,默认为登录用户
二、删除索引
DROP index ‘索引名’
三、创建索引
create index '索引名' on ‘表名’ (字段1,字段2)