Last updated on SEPTEMBER 26, 2013
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle 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!
~~~~~~~~~~~~~
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