ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RAC Hangs due to small cache size on SYS.AUDSES$ [ID 395314.1]

RAC Hangs due to small cache size on SYS.AUDSES$ [ID 395314.1]

原创 Linux操作系统 作者:spider0283 时间:2011-08-21 10:30:47 0 删除 编辑
修改时间 15-SEP-2010     类型 BULLETIN     状态 ARCHIVED  

PURPOSE
-------

Prevent hangs in RAC due to high login rate and low cache setting of AUDSES$ sequence.  
Default of 20 is not adequate in many cases.

 
PROBLEM:
--------

The default setting for the SYS.AUDSES$ sequence is 20, this is too low for a RAC system
where logins can occur concurrently from multiple nodes.  During high login rate
such low value can cause slowness and even hangs. Some of the symptoms are:
 - Checkpoint not completing on all RAC nodes
 - Waits expire on row cache enqueue lock dc_sequences
 - RAC hangs due to QMON deadlocking

During those hangs session login is not possible (or *extremely* slow) due 
to extremely high contention on the above sequence.

SOLUTION:
---------

Manually increase that sequence cache on each affected database:

alter sequence sys.audses$ cache 10000;

This is fixed in 10.2.0.3 patchset. (Affected releases 9i to 10.2.0.2)

REFERENCES
----------

bug:4390868 
bug:2855838




显示相关信息 相关的


产品
  • Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition

返回页首返回页首

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/38267/viewspace-705477/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-29

  • 博文量
    194
  • 访问量
    645969