ASM Queries (v$asm_diskgroup, v$asm_disk) Slow in 11.2.0.3.0 and Solaris
(Doc ID 1383019.1)
Last updated on AUGUST 04, 2018
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |