对象解锁

^/IiT-eJE0操作的数据库对象被其他会话锁定了。51Testing软件测试网7vu5g5i[QYV
通过查看v$session,v$locked_objects,all_objects可以查到是那个会话锁定了该资源。一般应该使得那个会话尽快提交他的事务，如果紧急，那么可以将那个会话KILL掉。51Testing软件测试网w1puPR[qu

.Nqv ^,{UqT{01、查询会话：
/f3F
KkMA0select a.object_name objectname,
&AnQs_ ?8f }m0       b.session_id,51Testing软件测试网3eCk:F [PT4G:Y.b
       c.serial#,
8q k_&? h'?0       c.program program,51Testing软件测试网F![es+]e'@
       c.username username,
y S7_n_
x7jEX{k0       c.command,51Testing软件测试网)u9Ii L-uzUP/jE
       c.machine machine,51Testing软件测试网mW r)Q-j4`
       c.lockwait51Testing软件测试网O!MqBP*br"]A
  from all_objects a, v$locked_object b, v$session c
:l,E(TLe?,o0 where a.object_id = b.object_id
e"od
E D6\;h0   and c.sid = b.session_id;51Testing软件测试网vY j*R R O!r

8_ gPEy1B0bdS02、kill会话：51Testing软件测试网)~(J5~ l(U'MS%G
alter   system   kill   session   'session_id,serial#' immediate;

M/x;V_*};u(dy!z0------------------------------------------------------------------------------------------

#W~$Py:R0如果执行上面的查询卡死没有反应，则可以进行下面的操作：
`9yl%E#j2{
q"|&S0        select * from v$locked_object;
.?g&D8V Tv0        select * from v$session where sid = 296;
%aXH9m TX+cNOF1aS0        select spid51Testing软件测试网O s?6tV1m(Jkj
          from v$process
C[H(J4Z,O:R;L:H0         where addr = (select paddr51Testing软件测试网/J%GQ*P"`*`og
                 from v$session51Testing软件测试网c(m S#nH3k ^U KQ
                where sid = 20951Testing软件测试网1iLja{l(n
                  and serial# = 18098);51Testing软件测试网9b7vGdJ{s%EV{
   51Testing软件测试网!vM6W!w.M
X RRX
杀掉主机进程： 51Testing软件测试网0?q"v#m Q*{+@-lM
        kill   -9   spid  
&mY[r
J8e5O*F0

Nu(U5bO
o'jal ZL0锁用户：

ORA-28000: the account is locked
q,tbh!ro;v0Cause: The user has entered wrong password consequently for maximum number of times specified by the user's profile parameter FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account
2h`t4qD'bo)z$]4lP0Action: Wait for PASSWORD_LOCK_TIME or contact DBA

导致原因：
iS\"E)UTe0用户多次频繁输入错误密码51Testing软件测试网WW
G|7?jY ]^
超过了FAILED_LOGIN_ATTEMPTS
\`Y3b5R^8Uhj+`0限制次数51Testing软件测试网z2MB4I Q$s@
DBA锁定账户

多用户同时更改某表同一条记录.

 51Testing软件测试网hU+i)k }W A