鎖(下),鎖(
(2)解鎖方法
alter system kill session '878,1773'; /*878為SID,1773為SERIAL#*/
select /*+ rule */ s.username,
decode(l.type,'tm','table lock','tx','row lock',null) lock_level,
o.owner,o.object_name,o.object_type,
s.sid,s.serial#,s.terminal,s.machine,s.program,s.osuser
from v$session s,v$lock l,dba_objects o
where l.sid = s.sid
and l.id1 = o.object_id(+)
and s.osuser = 'okf55657' and s.username = 'lbimk_babilon'
and s.username is not null
select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;
select b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session b where a.session_id = b.sid
and a.session_id = 745;
alter system kill session'767,19132';
select a.sid,a.serial#,c.object_name,a.sql_id
from v$session a,v$locked_object b,all_objects c
where a.sid=b.session_id
and b.object_id=c.object_id;
select spid from v$process
where addr = (
select paddr from v$session where sid = 767
);
找到對應的spid後,在後台用命令kill -9 spid殺掉OS進程。
鎖下面有一個小孔是幹什的?
鎖下面的孔是 鎖孔,插鑰匙的
鎖上面除了鎖孔外,剩下的就是旁邊的 機簧孔 裡面有一小段彈簧,
如果沒有這些裝有小彈簧的小孔 那麼任何鑰匙都可以開這把鎖了~~
Win7 怎設定 鎖定狀態下的密碼提示
開啟控制台-使用者帳戶和家長監護服務-更改WINDOWS密碼 用提示修改 去除密碼 給分吧