{"id":181,"date":"2012-03-02T02:25:17","date_gmt":"2012-03-02T02:25:17","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=181"},"modified":"2012-03-02T02:26:58","modified_gmt":"2012-03-02T02:26:58","slug":"awr-parameters","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=181","title":{"rendered":"AWR parameters"},"content":{"rendered":"<p><code><br \/>\n<script type=\"text\/javascript\"> \nfunction copy(what) {\n    window.clipboardData.setData('Text',what.value);\n}\nfunction paste(what) {\n    what.value = window.clipboardData.getData('Text');\n}\n<\/script><br \/>\nGet AWR parameters<\/p>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nselect<br \/>\n      extract( day from snap_interval) *24*60+<br \/>\n      extract( hour from snap_interval) *60+<br \/>\n      extract( minute from snap_interval ) \"Snapshot Interval\",<br \/>\n      extract( day from retention) *24*60+<br \/>\n      extract( hour from retention) *60+<br \/>\n      extract( minute from retention ) \"Retention Interval\"<br \/>\nfrom dba_hist_wr_control<br \/>\n\/<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<pre class=\"qcode\">\r\nselect\r\n      extract( day from snap_interval) *24*60+\r\n      extract( hour from snap_interval) *60+\r\n      extract( minute from snap_interval ) \"Snapshot Interval\",\r\n      extract( day from retention) *24*60+\r\n      extract( hour from retention) *60+\r\n      extract( minute from retention ) \"Retention Interval\"\r\nfrom dba_hist_wr_control\r\n\/\r\n<\/pre>\n<p>Modify snapshot settings<\/p>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nexec dbms_workload_repository.modify_snapshot_settings (retention => 30*24*60);<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<pre class=\"qcode\">\r\nexec dbms_workload_repository.modify_snapshot_settings (retention => 30*24*60);\r\n<\/pre>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Get AWR parameters select extract( day from snap_interval) *24*60+ extract( hour from snap_interval) *60+ extract( minute from snap_interval ) &#8220;Snapshot Interval&#8221;, extract( day from retention) *24*60+ extract( hour from retention) *60+ extract( minute from retention ) &#8220;Retention Interval&#8221; from dba_hist_wr_control \/ select extract( day from snap_interval) *24*60+ extract( hour from snap_interval) *60+ extract( minute from [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":179,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-181","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-2V","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=181"}],"version-history":[{"count":2,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/181\/revisions"}],"predecessor-version":[{"id":184,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/181\/revisions\/184"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/179"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}