oracle报错3135,oracle rac ORA-600[qerltcUserIterGet_1] ORA-08103

客户环境中表空间为bigfile，设置了maxsize 700G，当前使用率已经99%，在resize为900G后，错误消失，也不需要重建表。skdstdst ksedst1 ksedst dbkedDefDump ksedmp ksfdmp dbgexPhaseII

dbgexProcessError dbgeExecuteForErrordbgePostErrorKGE dbkePostKGE_kgsf

kgeadse kgerinv_internal kgerinv kgeasnmierr qerltcUserIterGet

qerltcAddUserIterationtoHash qerltcRowProcessingErrorHandler

qerltcInsertValues qerltcFetch insexeopiexe opipls opiodr rpidrus skgmstack

rpiswu2 rpidrv psddr0 psdnal pevm_EXECC pfrinstr_EXECC pfrrun_no_tool pfrrun

plsql_run pricar pricbr prient2 prient kkxrpc kporpc opiodr ttcpip opitsk

opiino opiodr opidrv sou2o opimai_real ssthrdmain main __libc_start_main

_start

MOS中ORA-600[qerltcUserIterGet_1]已知BUG如下：--发生在insert和重建索引同时操作时

Bug 5144934 - Wrong oereof value returned when error occurs in a batch - can cause ORA-600

--异常断开

Bug 9150510  OERI executing LOG ERRORS INTO portion of a SQL statement after an ORA-3113

Bug 14469565  ORA-600[qerltcUserIterGet_1] signaled with ORA-3135

Bug 19949485  ORA-28 followed by an ORA-600 [kcbnew_2] or similar

trace中process dump有大量的log file sync等待事件，如果只是通过resize表空间问题就不在出现，猜测存在未知bigfile的bug，也就是在批量写入bigfile时，而bigfile已经达到MAXSIZE，此时会出现ORA-600[qerltcUserIterGet_1]和报错ORA-08103。