Exadata DISK_REPAIR_TIME 조회 및 변경

1. DISK_REPAIR_TIME 파라미터 조회

select name,value
from v$asm_attribute where group_number=1 and name not like ‘template%’;

NAME                                         
VALUE

———————————————
———————————————

idp.type                                     
dynamic

idp.boundary                                 
auto

disk_repair_time                             
3.6h

phys_meta_replicated                         
true

failgroup_repair_time                        
24.0h

thin_provisioned                             
FALSE

content.type                                 
data

content.check                                
FALSE

au_size                                      
1048576

sector_size                                
  512

Default 값은 3.6h

2. 파라미터 변경 방법

ALTER DISKGROUP dgroupA SET ATTRIBUTE „DISK_REPAIR_TIME‟ = “5H”;