Waits on Event 'enq: TM - contention' While Executing DML on SYS.MON_MODS$ (Doc ID 2124915.1)

Last updated on APRIL 11, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Top User Events

Event                      Event Class      % Event   Avg Active Sessions

enq: TM - contention       Application       47.88    7.76  
gc buffer busy release     Cluster           19.01    3.08
CPU + Wait for CPU         CPU               14.05    2.28
buffer busy waits          Concurrency        3.40    0.55
IPC send completion sync   Other              1.64    0.27
 

Top SQL with Top Events

SQL ID            Planhash    Sampled # of Executions    % Activity    Event                    % Event    Top Row Source                % RwSrc    SQL Text

g00cj285jmgsw     1274408     3885                       46.19         enq: TM - contention     39.40      UPDATE STATEMENT              39.40      update sys.mon_mods$ set inser...     
                                                                       gc buffer busy release    4.17      UPDATE    4.17
                                                                       buffer busy waits         1.25      UPDATE    1.25
   .
   .
   .
00zqy3yd0r3p3                 3751                       6.77          enq: TM - contention      6.76    ** Row Source Not Available **    6.76     lock table sys.mon_mods$ in ex...

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms