ASMCA SLOW WHILE ADDING & DROPPING DISK OPERATIONS.
(Doc ID 2274497.1)
Last updated on MARCH 23, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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')
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')
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |