Bug 6270137 Unnecessary acquisition of the list header block in ASM-优快云博客

本文概述了Oracle ASM中出现的bug 6270137，该问题导致长时间查询ASM相关视图如v$asm_disk和v$asm_file，进而可能影响归档进程和LGWR等操作，严重拖慢实例速度。文章提供了临时解决方案，并列出了受影响的版本及修复补丁。

This note gives abrief overview of bug 6270137.
The content was last updated on: 27-MAY-2009
Click herefor details of each of the sections below.

Affects:

*Product (Component)*	Oracle Server (Rdbms)
*Range of versions believed* to be affected**	Versions BELOW 11.2
*Versions confirmed* as being affected**	10.2.0.4 10.2.0.3
Platforms affected	Generic (all / most platforms affected)

Fixed:

This issue is fixed in		11.2.0.1 (Base Release) 11.1.0.7 (Server Patch Set) 10.2.0.5 (Server Patch Set) 10.2.0.4 Patch 15 on Windows Platforms 10.2.0.3 Patch 31 on Windows Platforms
Symptoms:		Related To:
(None Specified)		Automatic Storage Management (ASM)

Description

There is some unnecessary acquisition of the list header block (LISTHEAD)

in ASM.

REDISCOVERY INFORMATION

A symptom of this bug is long times to query v$asm related views such as

v$asm_disk , v$asm_file.

As we hold lhbp unnecessarily during these long scans, a cascading effect is

possible on various processes (archiver, lgwr, ...)

potentially slowing down  instance(s) severely.

Sessions on ASM instances would wait for GCS lock open X , GCS lock esc X ,

buffer busy on a LISTHEAD buffer type...

Workaround

1. Until the fix is applied, disable dbconsole or Grid Control for the database/ASM

instance.

2. Stop any query referencing v$asm* views, specially v$asm_file.

HOOKS PSE:A204 PSE:A203 LIKELYAFFECTSXAFFECTS_10.2.0.1 XAFFECTS_V10020001 AFFECTS=10.2.0.1 XAFFECTS_10.2.0.2 XAFFECTS_V10020002AFFECTS=10.2.0.2 XAFFECTS_10.2.0.3 XAFFECTS_V10020003 AFFECTS=10.2.0.3XAFFECTS_10.2.0.4 XAFFECTS_V10020004 AFFECTS=10.2.0.4 XAFFECTS_11.1.0.6XAFFECTS_V11010006 AFFECTS=11.1.0.6 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMSXCOMP_RDBMS COMPONENT=RDBMS TAG_ASM ASM FIXED_10.2.0.5 FIXED_11.1.0.7FIXED_11.2.0.1 FIXED_WIN:A203P31 FIXED_WIN:A204P15

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.