博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
enq: JI - contention等待事件
阅读量:5008 次
发布时间:2019-06-12

本文共 1409 字,大约阅读时间需要 4 分钟。

Sessions waiting on this event are waiting on locks held during materialized view operations (such as refresh, alter) to prevent concurrent operations on the same materialized view. Solutions A materialized view cannot be fast refreshed more than once in a given period because it is serialized during the commit phase. Ensure that only one session at a time is performing the refreshes. If there is more than one session, the first session will work normally but the subsequent sessions will wait on "enq: JI - contention". Waits on this event can also be caused by on-commit time logic within the materialized view. Normally when a session updates record 1 and commits and then another session updates record 2 and commits, they do not have to wait for each other. However, when using an on commit-time fast refreshable materialized view on top of the table, we do have to wait when two sessions do totally unrelated transactions concurrently against the same table. This is not a problem when the table is modified infrequently or only by a single session, but it can be a big problem when applied to a table that performs a lot of modifications concurrently. Be sure to use on commit-time fast refreshable materialized views for implementing business rules only on tables that are not concurrently accessed or infrequently changed.

转载于:https://www.cnblogs.com/macleanoracle/archive/2013/03/19/2967895.html

你可能感兴趣的文章
Sunday串匹配算法 C语言实现
查看>>
学习方法
查看>>
Python成长笔记 - 基础篇 (二)python基本语法
查看>>
87JS原生:跑马灯效果
查看>>
6.方法_EJ
查看>>
html 字符串 生成 pdf 完美解决中文不显示
查看>>
记一次由于Java泛型类型擦除而导致的问题,及解决办法
查看>>
python列表逆序三种方法
查看>>
将笔记本变身WiFi热点
查看>>
SSU 479.Funny Feature
查看>>
pycharm修改代码模板支持中文输出
查看>>
poj 1904 强连通分量 tarjan
查看>>
史上最全的测试团队组建方法
查看>>
webview与壳交互的几种方式
查看>>
python3对于时间的处理
查看>>
PE破解win2008登录密码
查看>>
JVM垃圾回收机制
查看>>
结对编程2 微软学术搜索 第一部分——功能性bug
查看>>
StarUML
查看>>
程序员需要有多懒 ?- cocos2d-x 数学函数、常用宏粗整理 - by Glede
查看>>