查看死锁，解除死锁

--查看死锁：

select b.username,b.sid,b.serial#,b.sid||','||b.serial#,logon_time,c.owner,c.object_name,'alter system kill session '''||b.sid||','||b.serial#||''';'

      from v$locked_object a,v$session b,dba_objects c

      where a.session_id = b.sid 

      and c.object_id=a.object_id

      and c.object_name='TPA_NBI_PROV_PM_HP_MIN'

      order by b.logon_time;

--杀进程中的会话

alter system kill session 'sid,serial';

alter system kill session 'ssss';

 

--查看索引

select t.status,t.* from user_indexes  t

where t.table_name='TPA_NBI_PROV_PM_HP_MIN'