Oracle锁表信息处理步骤
select 'blocker(' || lb.sid || ':' || sb.username || ')-sql:' ||
qb.sql_text blockers,
'waiter (' || lw.sid || ':' || sw.username || ')-sql:' ||
qw.sql_text waiters
from v$lock lb, v$lock lw, v$session sb, v$session sw, v$sql qb, v$sql qw
where lb.sid = sb.sid
and lw.sid = sw.sid
and sb.prev_sql_addr = qb.address
and sw.sql_address = qw.address
and lb.id1 = lw.id1
and sw.lockwait is not null
and sb.lockwait is null
and lb.block = 1;
select p.spid,
a.serial#,
c.object_name,
b.session_id,
b.oracle_username,
b.os_user_name
from v$process p, v$session a, v$locked_object b, all_objects c
where p.addr = a.paddr
and a.process = b.process
and c.object_id = b.object_id
select b.owner,
b.object_name,
l.session_id,
l.locked_mode from v$locked_object l,
dba_objects b
SELECT sid, serial#, username, osuser FROM v$session;
select b.username, b.sid, b.serial#, logon_time
from v$locked_object a, v$session b
where a.session_id = b.sid
order by b.logon_time;
alter system kill session 'sid,serial#';
key | 描述 |
---|
If-Modified-Since | 缓存校验字段,值为资源最后一次的修改时间,即上次收到的Last-Modified值 |