ASM Queries (v$asm_diskgroup, v$asm_disk) Slow in 11.2.0.3.0 and Solaris
(Doc ID 1383019.1)
Last updated on FEBRUARY 16, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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!
~~~~~~~~~~~~~
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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |