Thu Sep 15 18:19:44 2011

Errors in file /oracle/admin/sptdi/bdump/sptdi2_j001_521192.trc:             

ORA-12012: error on auto execute of job 42078

ORA-27468: "EXFSYS.RLM$EVTCLEANUP" is locked by another process

Thu Sep 15 18:24:27 2011

>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=105

System State dumped to trace file /oracle/admin/sptdi/udump/sptdi2_ora_546026.tr

c

Thu Sep 15 18:35:44 2011

Errors in file /oracle/admin/sptdi/bdump/sptdi2_j001_521192.trc:

ORA-12012: 自动执行作业 42079 出错

ORA-27468: "EXFSYS.RLM$SCHDNEGACTION" 被另一进程锁定

Thu Sep 15 18:45:00 2011

Errors in file /oracle/admin/sptdi/bdump/sptdi2_j002_557904.trc:

ORA-12012: error on auto execute of job 42078

ORA-27468: "EXFSYS.RLM$EVTCLEANUP" is locked by another process

早上来了看到报这个错，然后他们把数据库重启了，不知道为什么要重启。

查了一下这个错误，是说EXFSYS用户下的RLM$EVTCLEANUP这个Job被另一个进程锁定锁定造成的。

处理办法：找到在运行这个job 的session，然后把这个session  kill掉。或者是看这个job需要的是什么资源， 被哪个锁了，然后kill掉锁这个资源的session.

这些job做什么用？

These jobs under EXFSYS schema are related to the Expression Filter feature in 10G.
The Expression Filter feature can be installed on an Oracle10G Standard or Enterprise Edition
database. It is supplied as a set of PL/SQL packages, a Java package, a set of dictionary tables,
and catalog views. All these objects are created in a dedicated schema named EXFSYS. This schema
is not part of the typical installation of the database and will not exist before the Expression Filter is installed.