{"id":95,"date":"2010-02-12T15:17:00","date_gmt":"2010-02-12T13:17:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2010\/02\/12\/oracle-awr\/"},"modified":"2010-08-24T22:35:18","modified_gmt":"2010-08-24T20:35:18","slug":"oracle-awr","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2010\/02\/12\/oracle-awr\/","title":{"rendered":"ORACLE AWR"},"content":{"rendered":"<div><i><span class=\"Apple-style-span\">Oracle Enterprise Manager => Advisor Central<\/span><\/i><span class=\"Apple-style-span\" style=\"font-weight: bold;\"><\/span><br \/><span class=\"Apple-style-span\" style=\"font-weight: bold;\"><br \/><\/span><br \/><span class=\"Apple-style-span\" style=\"font-weight: bold;\">AWR (Automatic Workload Repository)<\/span><br \/><i><span class=\"Apple-style-span\">staty<\/span><span class=\"Apple-style-span\">styki<\/span><span class=\"Apple-style-span\"> przechowywane w tabelach WRH$ w przestrzeni SYSAUX<\/span><\/i><span class=\"Apple-style-span\" style=\"font-weight: bold;\"><br \/><\/span><\/div>\n<div><span class=\"Apple-style-span\" style=\"font-weight: bold;\">warunki:<\/span><\/div>\n<div>STATISTICL_LEVEL= TYPICAL | ALL<br \/><b>widoki:<\/b><br \/>memory:<br \/>DBA_HIST_SGA<br \/>DBA_HIST_PGASTAT<br \/>DBA_HIST_PGA_TARGET_DEVICE <br \/>DBA_HIST_SGASTAT<br \/>DBA_HIST_BUFFER_POOL_STAT<br \/>DBA_HIST_DB_CACHE_ADVICE<br \/>DBA_HIST_SHARED_POOL_ADVICE<br \/>sql:<br \/>DBA_HIST_SQL_SUMMARY<br \/>DBA_HIST_SQLSTAT<br \/>DBA_HIST_SQL_PLAN<\/p>\n<p>other:<br \/>DBA_HIST_SYSSTAT<br \/>DBA_HIST_FILESTATXS <\/div>\n<div>DBA_HIST_WR_CONTROL<\/div>\n<div>DBA_HIST_SNAPSHOT<\/div>\n<div>DBA_HIST_DATABASE_INSTANCE<\/div>\n<div><\/div>\n<div>DBA_HIST_ACTIVE_SESS_HISTORY<\/div>\n<div><span class=\"Apple-style-span\" style=\"font-weight: bold;\">sprawdzenie cz\u0119stotliwo\u015bci:<\/span><\/div>\n<div>SELECT * FROM DBA_HIST_WR_CONTROL<\/div>\n<div><span class=\"Apple-style-span\" style=\"font-weight: bold;\">ustawienie cz\u0119stotliwo\u015bci:<\/span><\/div>\n<div>DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS ([retention &#8211; min],[interwal &#8211; min]);<\/div>\n<div><span class=\"Apple-style-span\" style=\"font-weight: bold;\">manualny snapshot:<\/span><\/div>\n<div>DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT();<\/div>\n<div><span class=\"Apple-style-span\" style=\"font-weight: bold;\">drop snapshot:<\/span><\/div>\n<div>DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE([low_id],[end_id]);<\/div>\n<div><span class=\"Apple-style-span\" style=\"font-weight: bold;\">raporty AWR:<\/span><\/div>\n<div>$oracle_home\/rdbms\/admin\/awrrpt.sql<\/div>\n<div>$oracle_home\/rdbms\/admin\/awrrpti.sql &#8211; z wyborem instancji<br \/><span class=\"Apple-style-span\" style=\"font-weight: bold;\">raporty ADDM (Automatic Database Diagnostic Monitor:<\/span><br \/><i><span class=\"Apple-style-span\">analiza danych z AWR pod wzgl\u0119dem w\u0105skich garde\u0142<\/span><\/i><span class=\"Apple-style-span\" style=\"font-weight: bold;\"> <\/span><br \/>$oracle_home\/rdbms\/admin\/addmrpt.sql<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Enterprise Manager => Advisor CentralAWR (Automatic Workload Repository)statystyki przechowywane w tabelach WRH$ w przestrzeni SYSAUX warunki: STATISTICL_LEVEL= TYPICAL | ALLwidoki:memory:DBA_HIST_SGADBA_HIST_PGASTATDBA_HIST_PGA_TARGET_DEVICE DBA_HIST_SGASTATDBA_HIST_BUFFER_POOL_STATDBA_HIST_DB_CACHE_ADVICEDBA_HIST_SHARED_POOL_ADVICEsql:DBA_HIST_SQL_SUMMARYDBA_HIST_SQLSTATDBA_HIST_SQL_PLAN other:DBA_HIST_SYSSTATDBA_HIST_FILESTATXS DBA_HIST_WR_CONTROL DBA_HIST_SNAPSHOT DBA_HIST_DATABASE_INSTANCE DBA_HIST_ACTIVE_SESS_HISTORY sprawdzenie cz\u0119stotliwo\u015bci: SELECT * FROM DBA_HIST_WR_CONTROL ustawienie cz\u0119stotliwo\u015bci: DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS ([retention &#8211; min],[interwal &#8211; min]); manualny snapshot: DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); drop snapshot: DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE([low_id],[end_id]); raporty AWR: $oracle_home\/rdbms\/admin\/awrrpt.sql $oracle_home\/rdbms\/admin\/awrrpti.sql &#8211; z wyborem instancjiraporty [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[12],"class_list":["post-95","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-awr"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/95","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=95"}],"version-history":[{"count":1,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/95\/revisions"}],"predecessor-version":[{"id":170,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/95\/revisions\/170"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}