ora00060怎么解决

1、执行下面SQL，先查看哪些表被锁住了:

18:09:22 SCOTT@wailon>select b.owner,b.object_name,a.session_id,a.locked_modefrom v$locked_object a,dba_objects bwhere b.object_id = a.object_id;

OWNER                          OBJECT_NAME          SESSION_ID LOCKED_MODE------------------------------ -------------------- ---------- -----------SCOTT                          TAB_DL                      144           3SCOTT                          TAB_DL                       21           3

2、查看引起死锁的会话18:09:24 SCOTT@wailon>select b.username,b.sid,b.serial#,logon_time 18:09:40   2  from v$locked_object a,v$session b18:09:40   3  where a.session_id = b.sid order by b.logon_time;

USERNAME                              SID    SERIAL# LOGON_TIME------------------------------ ---------- ---------- ------------SCOTT                                  21         53 27-SEP-13SCOTT                                 144        369 27-SEP-13

3、查看被阻塞的会话18:11:09 SCOTT@wailon>select * from dba_waiters;WAITING_SESSION HOLDING_SESSION LOCK_TYPE                  MODE_HELD  MODE_REQUESTED    LOCK_ID1   LOCK_ID2--------------- --------------- -------------------------- ---------- --------------- ---------- ----------            144              21 Transaction                Exclusive  Exclusive           655372       1186

4、可以提交或回滚阻塞的话，释放锁或者杀掉ORACLE进程: ALTER SYSTEM KILL SESSION 'SID,SERIAL#';    --对应上例中的21,53

5、最直接的方法就是：咨询专业技术人员来帮你操作完成