6.135 DBA_WORKLOAD_SQL_MAP

DBA_WORKLOAD_SQL_MAP contains the mapping information for skipping or replacing a SQL statement based on its sql_id during workload replay.

Column	Datatype	NULL	Description
REPLAY_ID	NUMBER(38)	NOT NULL	A foreign key to the ID column in the DBA_WORKLOAD_REPLAYs view
SCHEDULE_CAP_ID	NUMBER(38)	NOT NULL	The ID of a capture in the schedule
SQL_ID	VARCHAR2(13)	NOT NULL	SQL identifier of the SQL statement at the time of capture
OPERATION	VARCHAR2(7)		SKIP or REPLACE
SQL_ID_NUMBER	NUMBER		Internal representation of SQL_ID
REPLACEMENT_SQL_TEXT	VARCHAR2(4000)		When the value in the OPERATION column is SKIP, this column is NULL. When the value in the OPERATION column is REPLACE, this column shows the SQL statement to be used.

Note:

This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).