DBA_WORKLOAD_GROUP_ASSIGNMENTS
DBA_WORKLOAD_GROUP_ASSIGNMENTS displays all the workload capture groups and their assigned instances. A workload capture group is a subset of the captured workload. Each group accesses its own set of recorded database objects.
| Column | Datatype | NULL | Description |
|---|---|---|---|
REPLAY_DIR_NUMBER |
NUMBER(38) |
NOT NULL |
The value that is associated with the subdirectory under the replay directory. See REPLAY_DIR_NUMBER in DBA_WORKLOAD_REPLAYS. |
GROUP_ID |
NUMBER(38) |
NOT NULL |
The identifier of a workload capture group |
INSTANCE_NUMBER |
NUMBER(38) |
NOT NULL |
The instance a given group is assigned to |
See Also: “DBA_WORKLOAD_REPLAYS”