ORA-01403 when running DBMS_WORKLOAD_REPLAY.GET_DIVERGING_STATEMENT
Last updated on JUNE 03, 2016
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 9.2]
Information in this document applies to any platform.
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 (18.104.22.168) 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
The errors only occur from 9i capture.
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