ASM Queries (v$asm_diskgroup, v$asm_disk) Slow in 11.2.0.3.0 and Solaris (Doc ID 1383019.1)

Last updated on SEPTEMBER 26, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Solaris on SPARC (64-bit)

Symptoms

 

Issue is specific to Oracle Solaris platfoms only.


Queries on v$asm views (v$asm_diskgroup and v$asm_disk) are very slow from
11.2.0.3.0 Clustered ASM instances.

Results from v$asm_diskgroup_stat and v$asm_disk_stat, return almost immediately:

Node1 +ASM1:
~~~~~~~~~~~~~
SQL> select NAME from v$asm_diskgroup_stat
^-- Results return in "Elapsed: 00:00:00.00"   <-- Fast!

SQL> select NAME from v$asm_diskgroup;
^-- Results return in "Elapsed: 00:00:38.27"   <-- Slow!

SQL> select NAME from v$asm_disk;
^-- Results return in "Elapsed: 00:00:38.24"   <-- Slow!

Node2 +ASM2:
~~~~~~~~~~~~~
SQL> select NAME from v$asm_diskgroup_stat
^-- Results return in "Elapsed: 00:00:00.03"   <-- Fast!

SQL> select NAME from v$asm_diskgroup;
^-- Results return in "Elapsed: 00:00:38.22"   <-- Slow!

SQL> select NAME from v$asm_disk_stat;
^-- Results return in "Elapsed: 00:00:00.04"   <-- Fast!

SQL> select NAME from v$asm_disk;
^-- Results return in "Elapsed: 00:00:38.24"   <-- Slow!

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms