ORA-01403 when running DBMS_WORKLOAD_REPLAY.GET_DIVERGING_STATEMENT (Doc ID 1378311.1)

Last updated on JUNE 03, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 9.2.0.8 [Release 9.2]
Information in this document applies to any platform.

Symptoms

During replay, any error and data discrepancies between the replay system and the capture system are recorded as diverged calls.Information about a diverged call , including its SQL identifier(SQL_ID), SQL text, and bind values may be obtained by calling DBMS_WORKLOAD_REPLAY.GET_DIVERGING_STATEMENT

When trying to replay from 9i's capture (9.2.0.8) and obtain information on a diverging statement,
null column is found for sql_id in DBA_WORKLOAD_REPLAY_DIVERGENCE.

When running diverged call script, the following errors are produced:

ORA-01403: no data found
ORA-06512: at "SYS.DBMS_WORKLOAD_REPLAY", line 5858
ORA-06512: at line 18

Changes

The errors only occur from 9i capture.

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