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 When the value in the |