Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_WORKLOAD_USER_MAP

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
REPLAY_ID NUMBER   This is a foreign key to the ID column in the DBA_WORKLOAD_REPLAYS view
SCHEDULE_CAP_ID NUMBER   The ID of a capture in the schedule
CAPTURE_USER VARCHAR2(4000) NOT NULL The user name during the time of the workload capture
REPLAY_USER VARCHAR2(4000)   The user name to which the captured user should be remapped during replay. If the REPLAY_USER is null, the CAPTURE_USER is used during replay. In other words, the original user is used.