AWR Data in a Multitenant Environment

简介: AWR Data in a Multitenant Environment

• General AWR data

This data has no security implications. It is safe to be shared among all tenants in a CDB. This data is accessible by all PDBs and is captured in both CDB-level and PDB-level snapshots. Examples of general AWR data include the names of statistics, latches, and parameters.


• AWR data for a CDB

This category aggregates data for all tenants in a CDB. This data contains the status of the database as a whole and is useful only for the CDB administrator. This data is captured only in the CDB-level snapshots.


• AWR data for individual PDBs

This data describes the individual PDBs in a CDB. It shows container-specific data that represents the contribution of each individual PDB to the whole database instance. Therefore, this data is useful for both the CDB and the PDB administrators. This data is captured in both CDB-level and PDB-level snapshots.



To enable automatic snapshots for a PDB, the PDB administrator must connect to that PDB, set the value for the AWR_PDB_AUTOFLUSH_ENABLED parameter to true

相关文章
|
5月前
|
SQL Oracle 关系型数据库
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database (
77 2
|
5月前
|
容器
ADDM in a Multitenant Environment
ADDM in a Multitenant Environment
24 0
|
Oracle 关系型数据库 Unix
ORA-12705: Cannot access NLS data files or invalid environment
ORA-12705: Cannot access NLS data files or invalid environment
121 0
|
缓存
Error:Could not download ecj.jar : No cached version available for offline mode
Error:Could not download ecj.jar : No cached version available for offline mode
236 0
Error:Could not download ecj.jar : No cached version available for offline mode
Sap Ds Data is not available. Increase the time-out interval values in Debug | Options
Sap Ds Data is not available. Increase the time-out interval values in Debug | Options
124 0
|
存储 SQL
Application log save debug - how log data is persisted to database table
Application log save debug - how log data is persisted to database table
111 0
|
关系型数据库 Shell 网络安全