ORA-00600 [ktsmgmql_1] When Using the UNDO ADVISOR Package (Doc ID 824422.1)

Last updated on JUNE 13, 2013

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3
This problem can occur on any platform.

Symptoms

When when running the PL/SQL package DBMS_UNDO_ADV the following error is raised:

ORA-00600 [ktsmgmql_1]

The error can also be reproduce with the following simple testcase:

connect / as sysdba
.
DECLARE
STARTTIME DATE;
ENDTIME DATE;
our_res NUMBER(22);
BEGIN
STARTTIME := SYSDATE-732555;
ENDTIME := SYSDATE-732555;
our_res := "SYS"."DBMS_UNDO_ADV"."BEST_POSSIBLE_RETENTION"(STARTTIME, ENDTIME
);
END;
/

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