ORA-600 [kcbz_check_objd_typ_3] Seen On MMON Traces Or During DBMS_AQADM.CREATE_QUEUE_TABLE (Doc ID 1362768.1)

Last updated on OCTOBER 04, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.5 - Release: 10.2 to 10.2
Information in this document applies to any platform.

Symptoms

Error ORA-600 [kcbz_check_objd_typ_3] might happen in a variety of different scenarios in the database.

This document specifically addresses the occurrence of this error when executing DBMS_AQADM.CREATE_QUEUE_TABLE procedure or as reported in the database background MMON process trace files.

It is important to note that the following ORA-600 errors may occur for this same issue:

ORA-600 [kcbgtcr_1],
ORA-600 [kcbgcur_3]
ORA-600 [kcbzwb_4]

Changes

The three main aspects to trigger this error under such scenario discussed here on this article are:

i. Using database 10.2.x

[and]

ii. Creating an Advanced Queue table via DBMS_AQADM.CREATE_QUEUE_TABLE

[or]

iii. Configuring / using Oracle Service Workgroup Services feature (SYS$SERVICE_METRICS_TAB). Refer to following links for additional information of such feature:

   Workload Management with Services

   Measuring Performance by Service Using the Automatic Workload Repository

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms