-- --创建表用来存储check到的锁信息
create table T_LOCKED_SESSION
(
sid VARCHAR2(100),
serialno VARCHAR2(100),
eventno VARCHAR2(100),
event VARCHAR2(100),
module VARCHAR2(100),
username VARCHAR2(100),
osuser VARCHAR2(100),
prevexecstart VARCHAR2(100),
sqlid VARCHAR2(100),
lockedmode VARCHAR2(100),
action VARCHAR2(100),
inserttime VARCHAR2(100)
)
tablespace EGROUP_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
next 8
minextents 1
maxextents unlimited
pctincrease 0
);
---创建过程用来查询锁并将锁数据插入到前面表中
create or replace procedure p_check_locked_session
is
v_count varchar2(100);
v_sid varcha