Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to create an AWR report for PDB only in oracle

2025-01-27 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

Xiaobian to share with you how to create AWR report for PDB alone in oracle, I believe most people do not know much, so share this article for your reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

Only 12.2 has this feature.

http://docs.oracle.com/database/122/TGDBA/gathering-database-statistics.htm#TGDBA-GUID-D64AEB01-18FF-47EF-BB5C-A0611117D180

Oracle official blog

https://blogs.oracle.com/database4cn/122-%e5%a6%82%e4%bd%95%e5%8d%95%e4%b8%bapdb%e5%88%9b%e5%bb%baawr%e6%8a%a5%e5%91%8a

The procedure is as follows:

1)Set awr_pdb_autoflush_enabled=true for PDB:

alter session set container=PDB1;

alter system set awr_pdb_autoflush_enabled=true;

2)Set AWR snpashot interval to 1 hour:

select * from cdb_hist_wr_control;

DBID SNAP_INTERVAL RETENTION TOPNSQL CON_ID

2580889417 +40150 00:01:00.0 +00008 00:00:00.0 DEFAULT 3

execute dbms_workload_repository.modify_snapshot_settings(interval => 60);

select * from cdb_hist_wr_control;

DBID SNAP_INTERVAL RETENTION TOPNSQL CON_ID

2580889417 +00000 01:00:00.0 +00008 00:00:00.0 DEFAULT 3

3)Also note that AWR_SNAPSHOT_TIME_OFFSET is recommended to be set to 1000000 to prevent performance problems caused by too many PDBs starting snapshot collections at the same time

http://docs.oracle.com/database/122/REFRN/AWR_SNAPSHOT_TIME_OFFSET.htm#REFRN10325

alter system set AWR_SNAPSHOT_TIME_OFFSET=1000000 scope=both;

4)Wait for a while, wait for the snapshot to be generated, and then you can generate the AWR report:

SQL> select * from awr_pdb_snapshot;

Alternatively, you can manually create snapshot:

SQL> connect / as sysdba

SQL> alter session set container=PDB1;

SQL> exec dbms_workload_repository.create_snapshot();

Execute Generate AWR Report:

@?/ rdbms/admin/awrrpt

Specify the location of AWR Data

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

AWR_ROOT - Use AWR data from root (default)

AWR_PDB - Use AWR data from PDB

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report