分享一下ORACLE锁表，以及Sqldeveloper无法debug的解决方法

1，oracle锁表锁存储过程等
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;

SELECT sid, serial#, username, osuser FROM v$session;

ALTER system kill session '202,4';

select SID from V$ACCESS WHERE object=upper('SQLASPDELDATA');
select a.SID,a.SERIAL#,b.SPID from v$session a,v$process b where a.SID=323 and a.PADDR=b.ADDR;
alter system kill session '323,42990';

SELECT a.SID,
a.SERIAL#,
b.SPID
FROM v$session a,
v$process b
WHERE a.SID=
(SELECT SID FROM V$ACCESS WHERE object=upper('CMN_BATCH_PKG')
)
AND a.PADDR=b.ADDR;
ALTER system kill session '434,29021';

杀不掉的进程
WINDOWS系统
ORA-00031
命令：cmd: orakill orcl PSID

2，sqldeveloper无法debug存储过程：

BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE
(
host => '123.123.123.123', --本地IP地址
lower_port => null,
upper_port => null,
ace => xs$ace_type(privilege_list => xs$name_list('jdwp'),
principal_name => 'dbuser', --
principal_type => xs_acl.ptype_db)
);
END;