ITPub博客

首页 > 数据库 > Oracle > ASM file metadata operation

ASM file metadata operation

原创 Oracle 作者:parknkjun 时间:2016-12-06 00:43:14 0 删除 编辑

CAUSE

Event 'KSV master wait' indicates the process on the RDBMS side is waiting for a reply from a process on the ASM side.   In 11g, the parameter cell_offload_processing is set to TRUE.  Although that is a parameter is not applicable for non-Exadata databases, it caused ASM to try to deliver smart-scan results.   The issue was reported in Bug 11800170 - ASM IN KSV WAIT AFTER APPLICATION OF 11.2.0.2 GRID PSU.

After applying the workaround for this issue (see Solution below), a drop of a tablespace that used to take 13 minutes took 4 seconds.

SOLUTION

The following solutions are available for non-Exadata databases:

  1. For the quickest solution, use the workaround.  The workaround does not negatively impact non-Exadata databases. This parameter is to be set on the database instance.

    alter system set cell_offload_processing = false;
  2. Upgrade to 12.1, when available. OR
  3. Apply the 11.2.0.3 patch set  OR
  4. Apply one-off Patch 11800170, if available for your RDBMS and Grid Homes

ASM file metadata operation等待事件与KSV master wait相关,表示数据库端等待ASM端的响应,在11g中参数cell_offload_processing被设为true,这个参数并不适用于非exadata数据库,但是导致asm提供智能的扫描结果。

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

全部评论
DBA攻城狮

注册时间:2008-02-11

  • 博文量
    115
  • 访问量
    561387