问题描述
报错如下:
The statement failed with status 8103: ORA-08103: object no longer exists for input row 1236. (CC_OraStatement::rejectRecord, file CC_OraStatement.cpp, line 1,842)
专家解答
客户环境中表空间为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 insexe opiexe 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。