{"published":"2024-12-15 21:33:27","height":"190","version":"1.0","author_name":"HTN20190109","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2024%2F12%2F15%2F213327\" title=\"{AWR}\u81ea\u52d5\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u30ea\u30dd\u30b8\u30c8\u30ea\u3067\u306e\u8a2d\u5b9a - HTN20190109\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","image_url":null,"description":"\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u53d6\u5f97\u9593\u9694 2\u6642\u9593 \u4fdd\u5b58\u671f\u9593 \uff13\uff11\u65e5 \u53d6\u5f97\u3059\u308bSQL\u6570 \uff12\uff10\uff10 https://docs.oracle.com/cd/F19136_01/tgdba/gathering-database-statistics.html#GUID-62D01B30-2687-4821-A651-DC0E4AAC3B01 BEGIN DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS( retention => 31*24*60, interval => 120, topnsql => 200);END;/ select * from dba_hist\u2026","url":"https://htn20190109.hatenablog.com/entry/2024/12/15/213327","type":"rich","blog_title":"HTN20190109\u306e\u65e5\u8a18","categories":["\u6f14\u7fd2"],"width":"100%","blog_url":"https://htn20190109.hatenablog.com/","title":"{AWR}\u81ea\u52d5\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u30ea\u30dd\u30b8\u30c8\u30ea\u3067\u306e\u8a2d\u5b9a","author_url":"https://blog.hatena.ne.jp/HTN20190109/"}