enq: JI 等待事件

oracle等待事件名称

SELECT * FROM V$EVENT_NAME;

enq: JI - contention

Lock held during materialized view operations (such as refresh, alter) to prevent concurrent operations on the same materialized view

 

当前版本是11g r2

SQL> select * from v$version;
 
BANNER
---------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL> SELECT * FROM V$EVENT_NAME where name like 'enq: JI%';

EVENT#        917
EVENT_ID      2959147725
NAME enq:     JI - contention
PARAMETER1    name|mode
PARAMETER2    view object #
PARAMETER3    0
WAIT_CLASS_ID 1893977003
WAIT_CLASS#   0
WAIT_CLASS    Other