SYS.CD_ALTER_CTSBLE_BEFORE表被锁，怎么解决？

ora-04020:deadlock detected while trying to lock object
sys.cdc_alter_ctable_before

有谁知道怎么解决啊？

这位兄弟在玩啥，那么多锁

在编译？

晕倒又是一个bug:'(

Bug 3017048 - Ora-4020, Functional Index Locking During Invalidation Causing Self-Deadlock

Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.7.0
This problem can occur on any platform.

Symptoms
Running catalog.sql fails with and ORA-4020
ORA-04020: deadlock detected while trying to lock object SYS.CDC_ALTER_CTABLE_BEFORE


Cause
This is cause by bug 3017048 fixed in 10.1.0.2


Hdr: 3017048 9.2.0.0 RDBMS 9.2.0.0 RAM INDEX PRODID-5 PORTID-453 ORA-4020
Abstract: ORA-4020, FUNCTIONAL INDEX  LOCKING DURING INVALIDATION CAUSING SELF-DEADLOCK



Researching the issue on ora-4020 and SYS.CDC_CREATE_CTABLE_BEFORE lead to BUG 3228083 which was
experiencing similiar problems on the same object. This bug was closed as a duplicate of bug
3017048.

.


Solution
set the following in the INIT.ORA then restart the database


_system_trig_enabled=false
aq_tm_processes=0
job_queue_processes=0

then rerun CATALOG.SQL


After creating and running these scripts and the database is ok then restart
the database with the parameters taken out of the init.ora


As an Alternative, if your application is not using CDC, we can disable these triggers as follows:

SQL> conn / as sysdba
SQL> ALTER TRIGGER sys.cdc_alter_ctable_before DISABLE;
SQL> ALTER TRIGGER sys.cdc_create_ctable_after DISABLE;
SQL> ALTER TRIGGER sys.cdc_create_ctable_before DISABLE;
SQL> ALTER TRIGGER sys.cdc_drop_ctable_before DISABLE;

This will also prevent the deadlock from occurring.

.

[[i] 本帖最后由 ipzhw 于 2006-4-4 10:39 编辑 [/i]]

Functional Index      学习

o ,不错，解决了吗？楼主？

这个问题应该暂时无法解决吧，现在只是把被锁东西给屏蔽了，但执行CATALOG.SQL还是有报错信息，做exp时会报一堆DBMS.....的错误。:L

[[i] 本帖最后由 ipzhw 于 2006-4-6 09:25 编辑 [/i]]

数据仓库的东东，还是有人玩ＣＤＣ的

讨厌ＢＩ