My Oracle Support Banner

Refreshing a Materialized View = Errors in the Alert Log: ORA-600[ktecgsc:objdchk_kcbgcur_3] (Doc ID 2469511.1)

Last updated on OCTOBER 08, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

The following errors occur in the alert log in connection with a materialized view refresh:

ORA-00600: internal error code, arguments: [kdifind:objdchk_kcbgcur_3], [2537442], [1], [1073741824], [0], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [ktecgsc:objdchk_kcbgcur_3], [2537487], [4], [0], [0], [], [], [], [], [], [], []

 

The Call Stack Trace in the associated incident trace file might be similar to:

kcbgcur ktecgsc ktecgetsh ktecgshx ktspisc ktspgsp_main2 kdtgsp kdtgsph kdtgrs kdtInsRow
 kddiriDoInsert kddiriBufferRow kntxStmtExecute k
ntxslt kntxit kxtrexe updInlineTrigger
  updConstraintsAndART 
updrow qerupFetch qerstFetch qermvlgFetch qerstFetch updaul
   
updThreePhaseExe updexe opiexe

 

The block number in the customized incident dump corresponds to a pagetable segment header for a materialized view log:

----- Beginning of Customized Incident Dump(s) -----
Dump of buffer cache at level 10 for tsn=13 rdba=360819555
BH (0x7000110ffc47030) file#: 86 rdba: 0x1581ab63 (86/109411) class: 4 ba:0x7000110fc1f0000
set: 62 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,25
dbwrid: 5 obj: 52776751 objn: 118601 tsn: 13 afn: 86 hint: f                    <<<--- objn = object_id
hash: [0x7000110ef863a08,0x700011482725720] lru:
[0x70001100f1d6628,0x70001108f671980]
obj-flags: object_ckpt_list
ckptq: [0x70001119ffc5ab8,0x7000111ffaca018] fileq:
[0x700011493c8b288,0x70001102ef98e98] objq:
[0x700011516a66d30,0x700011516a66d30] objaq:
[0x700011516a66d10,0x700011516a66d10]
st: XCURRENT md: NULL fpin: 'ktswh53: ktstrn' tch: 1
flags: buffer_dirty redo_since_read
LRBA: [0x1350f.175eae.0] LSCN: [0x1e.3ea6d59e] HSCN: [0x1e.3ea6d6d7] HSUB:[3]
Printing buffer operation history (latest change first):
latched: 1, tail 20
...
<< see trace file for buffer history >>
...
buffer tsn: 13 rdba: 0x1581ab63 (86/109411)
scn: 0x001e.3ea6d6d7 seq: 0x03 flg: 0x00 tail: 0xd6d72303
frmt: 0x02 chkval: 0x0000 type: 0x23=PAGETABLE SEGMENT HEADER                    <<<--- PAGETABLE

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.