DFS lock handle in RAC
来源:互联网 发布:网络扫描工具有哪些 编辑:程序博客网 时间:2024/06/05 06:37
RAC环境中非常频繁的使用序列(sequence)。则'DFS lock handle'等待事件经常会出现。
通常的办法是增大序列缓存,且不使用排序选项即NOORDER。
- 创建序列时默认的cache是20,非排序NOORDER.
通过如下语句更新序列缓存:
- alter sequence SEQ_name cache 200;
RAC and sequences [ID 853652.1]中的一段话:
When caching + ordering is used and RAC is enabled (cluster_database = true),
then the session wanting to get the NEXTVAL of a sequence need to get
an exclusive instance SV lock before inserting or updating the sequence values
in the the shared pool. When multiple sessions want the nextval of the same sequence,
then some sessions will wait on 'DFS lock handle' waitevent with id1 equal to
the sequence number.
参考文档:
http://twit88.com/blog/2009/08/28/oracle-performance-dfs-lock-handle-and-oracle-sequence/
2011-03-03
- DFS lock handle in RAC
- Troubleshooting ‘DFS lock handle’ waits
- DFS lock handle & inactive transaction branch
- Oracle等待事件DFS lock handle
- enq:SQ contention / row cache lock / DFS lock handle(SV) 等待事件 说明
- enq:SQ contention / row cache lock / DFS lock handle(SV) 等待事件 说明
- enq:SQ contention / row cache lock / DFS lock handle(SV) 等待事件 说明
- dictionary cache —— row cache lock/enq: SQ - contention/DFS lock handle
- enq:SQ contention / row cache lock / DFS lock handle(SV) 等待事件 说明
- enq:SQ contention / row cache lock / DFS lock handle(SV) 等待事件 说明【转自dave偶像大神】
- 【翻译自mos文章】在12c中Create or Truncate Table时很慢,等待事件为 DFS Lock Handle wait
- oracle11g RAC GI ORA-15003: diskgroup "XXXX" already mounted in another lock name space
- Handle Garbage In
- Handle Error in VBA
- function handle in MATLAB
- Valid Pattern Lock --dfs
- hdu1195 Open the Lock (DFS)
- ZOJ3861:Valid Pattern Lock(DFS)
- 英特尔平板战略:MeeGo登陆AppUp开发者计划
- Microsoft Virtual PC 2007 快捷键
- 练习2-6:修改Fillvector.cpp使它能把vector中的所有元素连接成单独的一个字符串,并打印,但不要加上行号。
- 让 IDA 的 F5 插件失效
- 第一篇
- DFS lock handle in RAC
- ubuntu之tftp
- IOS开源项目汇总
- HttpClient 超时 用法
- SQL Server 2005 四个排名函数(row_number、rank、dense_rank和ntile)的比较
- Java/JSP中使用JDBC连接SQL Server 2005
- HTTP协议初步
- c语言输入输出缓冲区的概念
- 国内首款群件系统Fnotes 1800免费版共享