【翻译自mos文章】由于sys.audses$的cache值太小导致的RAC hang

最新推荐文章于 2024-07-19 08:15:00 发布

msdnchina

最新推荐文章于 2024-07-19 08:15:00 发布

阅读量1.1k

点赞数

分类专栏： Oracle DB Linux 文章标签： audses

Oracle DB 同时被 2 个专栏收录

773 篇文章 3 订阅

订阅专栏

Linux

295 篇文章 0 订阅

订阅专栏

由于sys.audses$的cache值太小导致的RAC hang

来源于：
RAC Hangs due to small cache size on SYS.AUDSES$ (文档 ID 395314.1)

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