DBMS_JOB和DBMS_SCHEDULER之间存在内部事务机制，将对DBMS_JOB_MAP表中的重复名称进行内部检查。并且此检查可能导致进程挂起。通
过在一个会话中使用DBMS_JOB创建一个作业，但是不提交，可以非常轻松地重现此内容。然后在第二个会话中创建另一个作业，该作业将挂起。引起其他进程的阻塞
id：2645984.1 –在SYS.SCHEDULER $ _DBMSJOB_MAP上删除引起行锁，将补丁30835853应用于Oracle 19c主目录，目前19c linux平台的RU并没有解决此问题，可以提单独的SR申请补丁
|
In this Document
APPLIES TO:Oracle Database – Enterprise Edition – Version 19.4.0.0.0 and later New dictionary table SYS.SCHEDULER$_DBMSJOB_MAP is created in 19c. SYMPTOMSApplication jobs are slow with “enq: TX – row lock contention” event on the below recursive SQL: DELETE FROM SYS.SCHEDULER$_DBMSJOB_MAP WHERE JOB_NAME NOT IN (SELECT NAME FROM SYS.OBJ$ WHERE NAME LIKE ‘DBMS_JOB$_%’)
CHANGESUpgrade to 19c CAUSEThe issue is due to the below bug: Bug 30835853 – DBMS_JOB.SUBMIT PROCEDURE BEHAVIOR CHANGE IN 19C After upgrade database to 19c, the new dictionary table SYS.SCHEDULER$_DBMSJOB_MAP is introduced. Application jobs may be slow due to below recursive SQL statement causing “enq: TX – row lock contention”. DELETE FROM SYS.SCHEDULER$_DBMSJOB_MAP WHERE JOB_NAME NOT IN (SELECT NAME FROM SYS.OBJ$ WHERE NAME LIKE ‘DBMS_JOB$_%’) SOLUTIONApply the Patch 30835853 for your version |
