To create AWR reports based on the automated metrics gathered:
Connect to the correct Pluggable:<\/p>\n\n\n\n
Find the dbid: If you want to create manually a AWR snapshot use the following:<\/p>\n\n\n\n Find the snapshot ids fom the following:<\/p>\n\n\n\n The following statement produces a HTML output of the AWR Report for specific snapshot ids on a RAC:<\/p>\n\n\n\n The following statement produces a HTML output for Active Session History (ASH):<\/p>\n\n\n\n Finally the following script can be executed as oracle OS user to produce ADDM reports:<\/p>\n\n\n\n To create AWR reports based on the automated metrics gathered:Connect to the correct Pluggable: select * from v$pdbs; Find the dbid:select * from v$database;<br> If you want to create manually a AWR snapshot use the following: select sys.dbms_workload_repository.create_snapshot('ALL') from dual; Find the snapshot ids fom the following: select dbid,instance_number,snap_id,to_char(BEGIN_INTERVAL_TIME,'dd\/mm\/yyyy hh24:mi;ss') startT,to_char(END_INTERVAL_TIME,'dd\/mm\/yyyy hh24:mi:ss') endT<br>from DBA_HIST_SNAPSHOT where […]<\/p>\n","protected":false},"author":1,"featured_media":106,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[59,58,55,56,57],"class_list":["post-163","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-addm","tag-ash","tag-awr","tag-monitoring","tag-tuning"],"blocksy_meta":[],"_links":{"self":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/163","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/comments?post=163"}],"version-history":[{"count":3,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/163\/revisions"}],"predecessor-version":[{"id":167,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/163\/revisions\/167"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/media\/106"}],"wp:attachment":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/media?parent=163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/categories?post=163"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/tags?post=163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}select * from v$pdbs;<\/code><\/p>\n\n\n\nselect * from v$database;<br><\/code><\/p>\n\n\n\nselect sys.dbms_workload_repository.create_snapshot('ALL') from dual;<\/code><\/p>\n\n\n\nselect dbid,instance_number,snap_id,to_char(BEGIN_INTERVAL_TIME,'dd\/mm\/yyyy hh24:mi;ss') startT,to_char(END_INTERVAL_TIME,'dd\/mm\/yyyy hh24:mi:ss') endT<br>from DBA_HIST_SNAPSHOT where dbid=(select dbid from v$database)<br>order by BEGIN_INTERVAL_TIME desc;<\/code><\/p>\n\n\n\nSELECT output FROM TABLE<br>(dbms_workload_repository.awr_global_report_html<br>(l_dbid=> <DBID>, --dbid select DBID from v$database<br>l_inst_num => '1,2', --instance single instance=1<br>l_bid => <SNAPID> ,--begin snap<br>l_eid =><SNAPID>, -- end snap<br>l_options => null )<br>);<\/code><\/p>\n\n\n\nSELECT output FROM TABLE ( dbms_workload_repository.ASH_GLOBAL_REPORT_HTML( l_dbid => <DBID>,<br>l_inst_num => null,<br>l_btime => to_date('09\/09\/2021 08:20:00','dd\/mm\/yyyy hh24:mi:ss'),<br>l_etime => to_date('09\/09\/2021 08:40:00','dd\/mm\/yyyy hh24:mi:ss')--,<br>)) ;<\/code><\/p>\n<\/div>\n<\/div>\n\n\n\n@?\/rdbms\/admin\/addmrpt.sql<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"