My Oracle Support Banner

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 AUGUST 31, 2021

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


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]


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

i. Using database 10.2.x


ii. Creating an Advanced Queue table via DBMS_AQADM.CREATE_QUEUE_TABLE


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


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

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