you can configure ADDM reports for Pluggable database(PDBs).
By default it is disabled. You need to enable it manually by executing following commands:
Note:
Default value of AWR_PDB_AUTOFLUSH_ENABLED is false
In Oracle 12c, By default ADDM report is enabled at Container level.
It work same in Oracle 19c as its work in Oracle 12c.
Enable ADDM reports in PDB databases
1. Login in the PDB database.
[oracle@ora admin]$ sqlplus system/manager@PDB
SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 15 11:41:32 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Last Successful login time: Tue Dec 15 2020 11:36:12 -05:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
2. Set the value of the following parameter.
SQL> ALTER SYSTEM SET AWR_PDB_AUTOFLUSH_ENABLED=TRUE;
SQL> show parameter AWR_PDB_AUTOFLUSH_ENABLED
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
awr_pdb_autoflush_enabled boolean TRUE
3. Set the AWR snapshot interval greater than 0 in the PDB.
SQL> EXEC dbms_workload_repository.modify_snapshot_settings(interval=>120);
Disable the ADDM reports in PDB
1. Login in the PDB database.
2. Set the value of the following parameter.
SQL> ALTER SYSTEM SET AWR_PDB_AUTOFLUSH_ENABLED=FALSE;
SQL> show parameter AWR_PDB_AUTOFLUSH_ENABLED
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
awr_pdb_autoflush_enabled boolean FALSE
3. Set the AWR snapshot interval greater than 0 in the PDB.
EXEC dbms_workload_repository.modify_snapshot_settings(interval=>0);
How to Run ADDM report on PDB
ADDM must be run from the Root Container database ( CDB )
Running ADDM from CDB will analyze the data of the PDB also and a sample ADDM looks like below.
[oracle@ora ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 15 11:58:12 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> show con_name;
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> @/u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/admin/addmrpt.sql
*****************************END****************************************
No comments:
Post a Comment