My Oracle Support Banner

Replay using DBMS_WORKLOAD_REPLAY.SET_SQL_MAPPING not skipping a SQL_ID In 19c (Doc ID 2694508.1)

Last updated on OCTOBER 12, 2021

Applies to:

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

Symptoms

On : 19.7.0.0.0 version, Real Application Testing

ACTUAL BEHAVIOR
---------------
RAT reply not able to skip a SQL_ID in 19c even after the patch for bug 30367193

Hi,

I am trying to skip one particular SQL id in RAT replay and its not getting skip, tried replace as well that didn't work as well.

Procedure used:

BEGIN
  DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE(capture_dir => 'MY_WORKLOAD_DIR');
END;
/


BEGIN
  DBMS_WORKLOAD_REPLAY.INITIALIZE_REPLAY (replay_name => 'TEST_REPLAY_1', replay_dir => 'MY_WORKLOAD_DIR');
END;
/

begin
DBMS_WORKLOAD_REPLAY.SET_SQL_MAPPING(sql_id=>'c05zv24089a1m',operation=>'SKIP',replacement_sql_text=>NULL);
commit;
end;
/

BEGIN
  DBMS_WORKLOAD_REPLAY.REMAP_CONNECTION (connection_id => 1 , replay_connection => 'ISDB');
END;
/

set pages 5000 lines 200 serveroutput on
set timing on
BEGIN
  DBMS_WORKLOAD_REPLAY.PREPARE_REPLAY(synchronization => 'SCN',connect_time_scale=> 150
  );
END;
/

set serveroutput on
 
BEGIN
  DBMS_WORKLOAD_REPLAY.START_REPLAY ();
END;
/

 

On target/replay side:

 

SQL>  select * from dba_workload_sql_map where sql_id='c05zv24089a1m';

REPLAY_ID SCHEDULE_CAP_ID SQL_ID OPERATI SQL_ID_NUMBER REPLACEMENT_SQL_TEXT
---------- --------------- ------------- ------- ------------- -------------- ---------------------------
7 0 c05zv24089a1m SKIP    1.3842E+19 >>>>>>>>>>>>>> SQL still executed on the replay side

 

 

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
Cause
Solution
References


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