Oracle教程 2023-02-24

Oracle 视图 DBA_WORKLOAD_USER_MAP 官方解释，作用，如何使用详细说明

`DBA_WORKLOAD_REPOSITORY_USER_MAP`视图显示系统中的所有分析仓库的用户和负载的映射关系。它的列如下：

USER_NAME：表示系统中的用户

WORKLOAD_ID：表示分析仓库中的负载

ENABLED：表示用户是否启用

以便使用该视图，你可以查询下面的例子：

SELECT USER_NAME，WORKLOAD_ID，ENABLED
FROM DBA_WORKLOAD_REPOSITORY_USER_MAP
WHERE USER_NAME=’TEST_USER’;

上面的查询将返回一个映射关系的列表，告诉你用户名为“TEST_USER”的用户所拥有的负载，以及它们是否启用。

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.