My Oracle Support Banner

MMON Slave Process Failed With ORA-600 [kdsgrp1-qetlbr]. (Doc ID 3017402.1)

Last updated on MAY 02, 2024

Applies to:

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

Symptoms

After upgrading from 11g to 19c MMON slave process occurs ORA-00600 [kdsgrp1-qetlbr] error.

*** SERVICE NAME:(SYS$BACKGROUND) 2024-03-25T07:03:14.885587+08:00
*** MODULE NAME:(MMON_SLAVE) 2024-03-25T07:03:14.885591+08:00
*** ACTION NAME:(Cleanup optimizer workload infor★) 2024-03-25T07:03:14.885594+08:00
*** CLIENT DRIVER:(SERVER) 2024-03-25T07:03:14.885597+08:00

2024-03-25T07:03:14.885434+08:00
Incident 22111 created, dump file: <diag trace>/<sid>/<sid>/incident/incdir_22111/<sid>_mz00_47782_i22111.trc
ORA-00600: internal error code, arguments: [kdsgrp1-qetlbr], [1], [58779445], [0], [], [], [], [], [], [], [], []

Current SQL is to purge history optimizer statistics.

----- Current SQL Statement for this session (sql_id=0h2255k026qr3) -----
delete /* QOSH:PURGE_OLD_STS *//*+ dynamic_sampling(4) */ from sys.wri$_optstat_tab_history where savtime < :1 and savtime > timestamp '1900-01-01 00:00:00 -0:0' and rownum <= :2

According to call stack, find out that the error relates to fetch by rowid operation.

[02]: kdsgrp1_assert [KDSRID]<-- Signaling
[03]: kdsgrp [KDSRID]
[04]: qetlbr []
[05]: qertbFetchByRowID [SQL_Execution]
[06]: qerflFetch [SQL_Execution]
[07]: qercoFetch [SQL_Execution]

Changes

Upgrade from 11g to 19c.

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


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