DBA_WORKLOAD_USER_MAP
contains all the mappings ever done until they are removed at some point.
The mappings are stored in a table made public through this view.
To remove old mappings, execute this statement:
SQL> delete * from DBA_WORKLOAD_USER_MAP;
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
This is a foreign key to the |
|
|
|
The ID of a capture in the schedule |
|
|
|
|
The user name during the time of the workload capture |
|
|
The user name to which the captured user should be remapped during replay. If the |
See Also: