ORA-20000

• 코드
• ORA-20000
• 원인
• ORACLE 10.2.0.5에서 11.2.0.1 까지 존재하는 BUG
• 증상
• Alert_sid.log 파일에

• *** ACTION NAME:(GATHER_STATS_JOB) 2019-02-26 22:00:09.040
  *** MODULE NAME:(DBMS_SCHEDULER) 2019-02-26 22:00:09.040
  *** SERVICE NAME:(SYS$USERS) 2019-02-26 22:00:09.040
  *** SESSION ID:(1356.49920) 2019-02-26 22:00:09.040
  WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1
  ORA-20000: Unable to set values for index SYS_MTABLE_000045D9E_IND_2: does not exist or insuffi
  cient privileges
  *** 2019-02-26 22:00:11.432
  GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYSTEM"','"SYS_EXPORT_FULL_01"','""', ...)
  ORA-20000: Unable to set values for index SYS_MTABLE_000045D9E_IND_2: does not exist or insuffi
  cient privileges
  *** 2019-02-26 22:23:01.444
  WARNING:Could not lower the asynch I/O limit to 184 for SQL direct I/O. It is set to -1
  WARNING:Could not lower the asynch I/O limit to 168 for SQL direct I/O. It is set to -1
  
  
  처럼 날짜와 붉은색 문구가 반복됨
• 해결
• 11.2.0.2 이상 버전으로 UPGRADE
  10.2.0.5.2 PSU 중 BUG 번호 9772888가 포함된 Patch 
• 참고 MOS 문서번호 & 기타
• 'Warning:Could not Lower the Asynch I/O Limit to 224 for SQL direct I/O. It is set to -1' After Upgrading To 10.2.0.5 (Doc ID 1155445.1)