ENQ: UL CONTENTION FOR HIGH CONCURRENCY ON TEXT INDEX WITH "SYNC ON COMMIT"
(Doc ID 2758088.1)
Last updated on APRIL 17, 2023
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...
...
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 |