symptoms : when awr auto purge fails over and over, it need to delete awr data (wrh$~~) or to increase awr runtime window.
1. get the default setting
sqlplus / as sysdba
oradebug setmypid
oradebug unit_test kebm_dmp_slv_attrs kewrmapsa_
=> default runtime : 900 cputime : 300
2. increase cputime/runtime
sqlplus / as sysdba
oradebug setmypid
oradebug unit_test kebm_set_slv_attrs kewrmapsa_ retain retain 3600 3600 retain retain
=> runtime : 3600 (1 hour) cputime : 3600 (1 hour)
3. restore default value
sqlplus / as sysdba
oradebug setmypid
oradebug unit_test kebm_set_slv_attrs kewrmapsa_ retain retain 900 300 retain retain
'RDB > Oracle' 카테고리의 다른 글
oracle 12c rac scm0 프로세스 (0) | 2018.09.13 |
---|---|
awr 테이블 데이터 지우기 (0) | 2018.09.06 |
awr mmon trace 뜨기 (0) | 2018.08.31 |
awr 파티션 수동 재생성 (0) | 2018.08.31 |
oracle 12c json (0) | 2018.08.27 |