Last updated on JUNE 03, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [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 (22.214.171.124) 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
Million Knowledge Articles and hundreds of Community platforms