{"blog_url":"https://htn20190109.hatenablog.com/","width":"100%","provider_name":"Hatena Blog","url":"https://htn20190109.hatenablog.com/entry/2024/12/14/133003","published":"2024-12-14 13:30:03","author_url":"https://blog.hatena.ne.jp/HTN20190109/","title":"{SQL\u8a08\u753b\u7ba1\u7406}SQL\u7ba1\u7406\u30d9\u30fc\u30b9\u3092\u8a2d\u5b9a","categories":["\u6f14\u7fd2"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2024%2F12%2F14%2F133003\" title=\"{SQL\u8a08\u753b\u7ba1\u7406}SQL\u7ba1\u7406\u30d9\u30fc\u30b9\u3092\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","height":"190","author_name":"HTN20190109","version":"1.0","image_url":null,"blog_title":"HTN20190109\u306e\u65e5\u8a18","type":"rich","description":"\u30c7\u30a3\u30b9\u30af\u9818\u57df\u4f7f\u7528\u91cf\uff12\uff10\uff05 \u6d88\u53bb\u65b9\u91dd\uff13\uff10\u9031 https://docs.oracle.com/cd/F19136_01/tgsql/managing-sql-plan-baselines.html#GUID-DE976D2B-DBAD-498F-B933-D16B06CA9D2A beginDBMS_SPM.CONFIGURE ( 'space_budget_percent',20);end;/ beginDBMS_SPM.CONFIGURE ( 'plan_retention_weeks',30);end;/ SELECT PARAMETER_NAME, PARAMETER_VALUE FROM\u2026"}