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 10.2.0.1 to 10.2.0.5 [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.
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
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 |
| Changes |
| Cause |
| Solution |
| References |