ASMCA SLOW WHILE ADDING & DROPPING DISK OPERATIONS. (Doc ID 2274497.1)

Last updated on JUNE 12, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

ASMCA takes around 6 mins while adding/dropping a disk in ASMCA GUI.

asmca-170511AM060112.log :

[AWT-EventQueue-0] [ 2017-05-11 06:02:11.920 AST ] [UsmcaLogger.logEntry:115] Entering oracle.sysman.assistants.usmca.backend.USMDiskGroupManager Method :
fetchFailureGroups [AWT-EventQueue-0]
[ 2017-05-11 06:02:11.921 AST ][SQLEngine.doSQLSubstitution:2414] The substituted sql statement:=select UNIQUE disk.FAILGROUP||'|'||disk.FAILGROUP_TYPE
from v$asm_disk disk,v$asm_diskgroup dg where dg.name='WFREC' and dg.group_number=disk.group_number
[AWT-EventQueue-0] [ 2017-05-11 06:02:12.918 AST ] [UsmcaLogger.logExit:124] Exiting oracle.sysman.assistants.usmca.backend.USMDiskGroupManager Method :fetchFailureGroups
[AWT-EventQueue-0] [ 2017-05-11 06:02:12.935 AST ] [UsmcaLogger.logEntry:115] Entering oracle.sysman.assistants.usmca.backend.USMDiskGroupManager Method :fetchDisks
[AWT-EventQueue-0] [ 2017-05-11 06:02:12.937 AST ][SQLEngine.doSQLSubstitution:2414] The substituted sql statement:=select dk.GROUP_NUMBER||'|'||dk.PATH||'|'||dk.HEADER_STATUS||'|'||nvl(dk.NAME,
'USMCA_NULL')||'|'||nvl(dk.FAILGROUP,'USMCA_NULL')||'|'||round(nvl(dk.TOTAL_MB,0))||'|'||dk.library||'|'||dk.FAILGROUP_TYPE FROM v$asm_disk dk, v$asm_diskgroup dg where
dk.GROUP_NUMBER=dg.GROUP_NUMBER and dg.NAME='WFREC' and dk.header_status='MEMBER' order by path
[AWT-EventQueue-0] [ 2017-05-11 06:02:13.943 AST ] [UsmcaLogger.logInfo:143] All disks in the instance fetched successfully. Check
/dbtop/app/oracle/cfgtoollogs/asmca/asmca-170511AM060112.log for details.
[AWT-EventQueue-0] [ 2017-05-11 06:02:13.943 AST ] [UsmcaLogger.logExit:124] Exiting oracle.sysman.assistants.usmca.backend.USMDiskGroupManager Method :fetchDisks
[AWT-EventQueue-0] [ 2017-05-11 06:02:21.197 AST ] [UsmcaLogger.logInfo:143] <<------- Here it was waiting for 6 minutes while waiting for dialog
[Thread-61] [ 2017-05-11 06:08:31.223 AST ] [UsmcaLogger.logInfo:143]continue with processing...
[Thread-61] [ 2017-05-11 06:08:31.224 AST ] [UsmcaLogger.logEntry:115] Entering oracle.sysman.assistants.usmca.model.UsmcaModel Method : performOperation
[Thread-61] [ 2017-05-11 06:08:31.224 AST ] [UsmcaLogger.logEntry:115]Entering oracle.sysman.assistants.usmca.backend.USMDiskGroupManager Method :dropDisks
[Thread-61] [ 2017-05-11 06:08:31.225 AST ][SQLEngine.doSQLSubstitution:2414] The substituted sql statement:=select count(*) from v$ASM_DISKGROUP where name=upper('WFREC')
[Thread-61] [ 2017-05-11 06:08:32.184 AST ][SQLEngine.doSQLSubstitution:2414] The substituted sql statement:=select state from v$asm_diskgroup where name=upper('WFREC')

 

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