Spatial index rebuilds
Dear Community,
Had some issues with the amount of redo and Undo when spatial indexes are rebuilt.
Platform Linux RHEL 5, x86-64, Oracle 11.2.0.3
Error in the Oracle alert:
Tue Nov 06 13:05:44 2012
Errors in file /opt/oracle/diag/rdbms/btodb01/btodb01/trace/btodb01_j000_22170.trc:
ORA-12012: error on auto execute of job "SYS"."BT_REFRESH_FAST_ACCESS"
ORA-13236: internal error in R-tree processing: [MDRCNCCMTTXNh]
ORA-13249: mdrcncupdidx:13
ORA-13236: internal error in R-tree processing: [insertion at root (mdrbin_mem_ins_rt)]
ORA-13236: internal error in R-tree processing: [integrating leaf bucket (mdrbin_optmz_mem_ins_node)]
ORA-13236: internal error in R-tree processing: [node integration exception (mdrbin_intgrt_leaf_bckt)]
Had some issues with the amount of redo and Undo when spatial indexes are rebuilt.
Platform Linux RHEL 5, x86-64, Oracle 11.2.0.3
Error in the Oracle alert:
Tue Nov 06 13:05:44 2012
Errors in file /opt/oracle/diag/rdbms/btodb01/btodb01/trace/btodb01_j000_22170.trc:
ORA-12012: error on auto execute of job "SYS"."BT_REFRESH_FAST_ACCESS"
ORA-13236: internal error in R-tree processing: [MDRCNCCMTTXNh]
ORA-13249: mdrcncupdidx:13
ORA-13236: internal error in R-tree processing: [insertion at root (mdrbin_mem_ins_rt)]
ORA-13236: internal error in R-tree processing: [integrating leaf bucket (mdrbin_optmz_mem_ins_node)]
ORA-13236: internal error in R-tree processing: [node integration exception (mdrbin_intgrt_leaf_bckt)]
0