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

This article mainly shows you "how to modify AWR default collection information", the content is simple and easy to understand, clear organization, I hope to help you solve doubts, let Xiaobian lead you to study and learn "how to modify AWR default collection information" this article bar.

Query AWR default collection information

SELECT * FROM DBA_HIST_WR_CONTROL;

Modify snapshot collection interval to 30 minutes and retention time to 10 days

SQL> BEGIN

2 DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(interval=>30,retention=>10*24*60);

3 end;

4 /

PL/SQL procedure successfully completed

The above is "how to modify AWR default collection information" all the content of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

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.