Oracle constraint / locked - 数据库主外键约束 和 死锁查询

accoreding to the constraint key name, acknowledge the detail relevant infos.

select * from dba_constraints where constraint_name='MSCP_T_CHKLST_ST_PRDCT_PR_FK1'

 

the table_nae column is the goal.

 

table locked:

select s.username, l.session_id,s.serial#, s.lockwait,s.status,s.machine,s.program from v$session s,v$locked_object l where s.sid = l.session_id;  

 

alter system kill session '564,347';