DBA_HIST_WR_SETTINGS

5.86 DBA_HIST_WR_SETTINGS

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

Note:

This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).