Email: service@parnassusdata.com 7 x 24 online support!

Oracle ORA-600 [kcbgcur_9] "Block class pinning violation"

Oracle ORA-600 [kcbgcur_9] "Block class pinning violation"

Format: ORA-600 [kcbgcur_9] [a] [b] [c] [d]

VERSIONS:

versions 8.0 to 10.0

DESCRIPTION:

Buffers are pinned in a specific class order to prevent internal deadlocks.

This exception means there is a class violation with the current

buffers pinned in the wrong class order, or duplicate buffers of

the same class.

May occur with an ORA-372 error when trying to update read-only

tablespace or partition via direct load.

ARGUMENTS:

Arg [a] The Database Block Address (DBA)

Arg [b] The buffer class

Arg [c] Block class order mask

Arg [d] Block class checking mask

FUNCTIONALITY:

BUFFER CACHE

IMPACT:

PROCESS FAILURE

NON CORRUPTIVE - No underlying data corruption.

SUGGESTIONS:

Check all system hardware (disk, memory) to ensure there are no

errors.

 

NB Bug Fixed Description

10061015

11.2.0.2.3,

11.2.0.2.BP08,

11.2.0.3, 12.1.0.0

ORA-600 [ktfbhget:clsviol_kcbgcur_9] can occur on

transported in tablespace

9407198 11.2.0.3, 12.1.0.0 "LOG ERRORS INTO" can cause ORA-600 [kcb***] or hang

scenarios

9133601 11.2.0.1 ORA-600 [kcbgcur_9] from MERGE into an IOT

8459467 10.2.0.5, 11.2.0.1 ORA-600 [ktfbhget:clsviol_kcbgcur_9] attempting to

ONLINE a tablespace

7644703 10.2.0.5, 11.2.0.1 OERI[kcbgcur_9] on alter tablespace online

4917666 10.2.0.3, 11.1.0.6 OERI[kcbgcur_9] from type constructor

8778379 10.2.0.5 Fix event 10227 in 10.2 ORA-600[kcbgcur_3] or ORA-

600[kcbgcur_9]

3655948 10.1.0.5, 10.2.0.1 OERI:kcbgcur_9 during disconnect with distributed

transaction

3127116 9.2.0.5, 10.1.0.2 OERI:kcbgcur_9 during rollback of DML in ASSM segment

2771042 9.2.0.6, 10.1.0.2 OERI[kcbgcur_9] when performing DML on an IOT with an

FGA policy

2747873 9.2.0.8, 10.1.0.2 DBMS_SPACE.UNUSED_SPACE may fail with

OERI:kcbgcur_9

2722809 9.2.0.4, 10.1.0.2 OERI:kcbgcur_9 on direct load into AUTO space managed

segment

2716406 10.1.0.2 OERI[kcbgcur_9] executing DBMS_SPACE.FREE_BLOCKS

procedure on bitmapped segment

2619895 9.2.0.8, 10.1.0.2 Dump / OERI:kcbgcur_9 using PLSQL in SET clause of

MERGE .. UPDATE

2392885 9.2.0.4, 10.1.0.2 Direct path load may fail with OERI:kcbgcur_9 /

OERI:ktfduedel2

2311214 9.0.1.4, 9.2.0.2,

10.1.0.2 OERI:KCBGCUR_9 possible for SQL against IOT

1785175 9.2.0.2, 10.1.0.2 OERI:kcbgcur_9 from CLOB TO CHAR or BLOB TO RAW

conversion

4124059 9.2.0.8 OERI[kcbget_31] / similar KCB errors in single instance

2202310 9.0.1.4, 9.2.0.1 OERI:KCBGCUR_9 possible from SMON dropping a rollback

segment in locally managed tablespace

2035267 9.0.1.3, 9.2.0.1 OERI:KCBGCUR_9 possible during TEMP space operations

1804676 8.1.7.3, 9.0.1.3,

9.2.0.1

OERI:KCBGCUR_9 possible from ONLINE REBUILD INDEX

with concurrent DML

1397075 8.1.7.2, 9.0.1.0 OERI:KCBGCUR_9 from SMON during temp seg cleanup for

segment in read only LOCALLY MANAGED TABLESPACE