My Oracle Support Banner

ENQ: UL CONTENTION FOR HIGH CONCURRENCY ON TEXT INDEX WITH "SYNC ON COMMIT" (Doc ID 2758088.1)

Last updated on APRIL 07, 2022

Applies to:

Oracle Text - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.

Symptoms

All Oracle Text Mandatory Patches for 12.2 per Doc ID 2644957.1 have been applied.

A number of sessions waiting with event "enq: UL - contention".

Below is the statement being waited on by those sessions:

begin ctxsys.drvdml.com_sync_index(:idxname, :idxmem, :partname); end;


The AWR report shows:

Top 10 Foreground Events by Total Wait Time

Event                             Waits         Total Wait Time (sec)    Avg Wait   % DB time    Wait Class
enq: UL - contention                  79,851       122,3K               1531.06ms      94.5      Application
DB CPU                                               ...                                4.9                          ....
...

Top SQL with Top Events

SQL ID Plan Hash Executions % Activity Event % Event Top Row Source % Row Source SQL Text Container Name
ddr8uck5s5kp3 11943 96.81 enq: UL - contention 93.39 ** Row Source Not Available ** 93.39 begin ctxsys.drvdml.com_sync_i...
...

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.