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

This article mainly introduces "how to create AWR for PDB level on Oracle12.2 or higher". In daily operation, I believe many people have doubts about how to create AWR for PDB level on Oracle12.2 or higher. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "how to create AWR for PDB level on Oracle12.2 or higher version". Next, please follow the editor to study!

This is a new feature in version 12.2 or later.

Oracle Database Performance Tuning Guide

12c Release 2 (12.1)

6.2.7 Managing Automatic Workload Repository in a Multitenant Environment

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

You can follow these detailed steps to enable and create AWR reports at the PDB level.

1) set awr_pdb_autoflush_enabled=true at the PDB level:

Alter session set container=PDB1;alter system set awr_pdb_autoflush_enabled=true

2) set the AWR snapshot correctly

Select * from cdb_hist_wr_control;DBID SNAP_INTERVAL RETENTION TOPNSQL CON_ID2580889417 + 40150 00DEFAULT 3execute dbms_workload_repository.modify_snapshot_settings 01DEFAULT 3execute dbms_workload_repository.modify_snapshot_settings (interval = > 60); select * from cdb_hist_wr_control;DBID SNAP_INTERVAL RETENTION TOPNSQL CON_ID2580889417 + 0000001DEFAULT 3execute dbms_workload_repository.modify_snapshot_settings 00.0 + 000080000Rod 00.0 DEFAULT 3

3) also set AWR_SNAPSHOT_TIME_OFFSET to 1000000 to avoid performance problems when multiple PDB create snapshots at the same time.

Oracle Database 12c Release 2Database Reference 1.26 AWR_SNAPSHOT_TIME_OFFSET http://docs.oracle.com/database/122/REFRN/AWR_SNAPSHOT_TIME_OFFSET.htm#REFRN10325alter system set AWR_SNAPSHOT_TIME_OFFSET=1000000 scope=both;AWR_SNAPSHOT_TIME_OFFSET

AWR_SNAPSHOT_TIME_OFFSET specifies an offset for the Automatic Workload Repository (AWR) snapshot start time.

PropertyDescription

Parameter type

Integer

Default value

There is no offset by default.

Modifiable

ALTER SYSTEM

Modifiable in a PDB

No

Range of values

0-3599, or the special value 1000000

Basic

No

Oracle RAC

Multiple instances should use the same value

AWR snapshots normally start at the top of the hour (12:00, 1:00, 2:00, and so on). This parameter allows DBAs to specify an offset for the AWR snapshot start time.

This is a useful parameter to avoid CPU spikes from multiple instances all starting their AWR snapshots at the same time. If you have a large system with many instances on it (like many Exadata installations), and you are experiencing such CPU spikes, this parameter can be very useful.

The parameter is specified in seconds. Normally, you set it to a value less than 3600. If you set the special value 1000000 (1000000), you get an automatic mode, in which the offset is based on the database name.

The automatic mode is an effective way of getting a reasonable distribution of offset times when you have a very large number of instances running on the same node.

4) wait 1-2 hours to automatically generate a snapshot:

Select * from awr_pdb_snapshot; or you can manually create a snapshot: SQL > connect / as sysdbaSQL > alter session set container=PDB1;SQL > exec dbms_workload_repository.create_snapshot (); create an AWR report: @? / rdbms/admin/awrrptSpecify the location of AWR Data~~AWR_ROOT-Use AWR data from root (default) AWR_PDB-Use AWR data from PDB * * Use the location AWR_PDB for a PDB level report

5) reference documentation

How to create an AWR report at PDB level 12.2 or later (document ID 2469637.1) .docx here, the study on "how to create AWR for PDB level on Oracle12.2 or later" is over. I hope you can solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.