Oracle 视图 DBA_WORKLOAD_GROUP_ASSIGNMENTS 官方解释，作用，如何使用详细说明
本站中文解释
DBA_WORKLOAD_GROUP_ASSIGNMENTS（Oracle视图）是一个基于数据库访问量的视图，这一视图主要用于查看数据库用户分配到数据库工作负载下的组，例如:工作负载组、应用程序组等。此外，它还会显示：数据库中的每个用户在各工作负载下的使用权限。
使用此视图的方式如下：
1、查看数据库中的用户分配的工作负载组：
SELECT * FROM DBA_WORKLOAD_GROUP_ASSIGNMENTS;
2、查看特定用户的工作负载组：
SELECT * FROM DBA_WORKLOAD_GROUP_ASSIGNMENTS WHERE USERNAME=”;
3、查看特定工作负载组下的用户：
SELECT * FROM DBA_WORKLOAD_GROUP_ASSIGNMENTS WHERE WORKLOAD_GROUP=”;
4、查看特定用户在特定工作负载组下的使用权限：
SELECT * FROM DBA_WORKLOAD_GROUP_ASSIGNMENTS WHERE USERNAME=” AND WORKLOAD_GROUP=”;
官方英文解释
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 |
|---|---|---|---|
|
|
|
|
The value that is associated with the subdirectory under the replay directory. See |
|
|
|
|
The identifier of a workload capture group |
|
|
|
|
The instance a given group is assigned to |
See Also:
“DBA_WORKLOAD_REPLAYS”
