Oracle教程 2023-02-24

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

Oracle视图DBA_HIST_WR_SETTINGS是Oracle数据库中查看最近应用到活动写请求的参数的视图，可用于查看Oracle数据库在不同时间和不同变量上的写操作和活动设置选项的变更记录。

查询该视图的样例语句为：

SELECT * FROM DBA_HIST_WR_SETTINGS ORDER BY BEGIN_INTERVAL_TIME;

DBA_HIST_WR_SETTINGS displays the settings and metadata for the Workload Repository.

Column Datatype NULL Description

Column	Datatype	NULL	Description
`LOCAL_AWRDBID`	`NUMBER`	`NOT NULL`	Database ID of the local database
`VIEW_LOCATION`	`VARCHAR2(8)`		Data source of the DBA_HIST dictionary views. Possible values include: `AWR_PDB`: Views display AWR data stored in the PDB. `AWR_ROOT`: Views display AWR data stored in the root.
`CON_ID`	`NUMBER`		The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire multitenant container database (CDB). This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

LOCAL_AWRDBID

NUMBER

NOT NULL

Database ID of the local database

VIEW_LOCATION

VARCHAR2(8)

Data source of the DBA_HIST dictionary views. Possible values include:

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

0: This value is used for rows containing data that pertain to the entire multitenant container database (CDB). This value is also used for rows in non-CDBs.
1: This value is used for rows containing data that pertain to only the root
n: Where n is the applicable container ID for the rows containing data

分享到：