{"provider_name":"Hatena Blog","description":"DBA_SQL_PLAN_DIRECTIVES.STATE \u306e\u5024\u3068\u610f\u5473 12.1.0.1 NEW: E-Rows \u3068 A-Rows \u304c\u9055\u3063\u3066\u4f5c\u6210\u3055\u308c\u305f MISSING_STATS: \u6b21\u56de\u7d71\u8a08\u53ce\u96c6\u6642\u306b\u62e1\u5f35\u7d71\u8a08\u3092\u53ce\u96c6\u3055\u308c\u308b\u3002\u305d\u308c\u307e\u3067\u306f\u30c0\u30a4\u30ca\u30df\u30c3\u30af\u30fb\u30b5\u30f3\u30d7\u30ea\u30f3\u30b0\u304c\u884c\u308f\u308c\u308b\u3002 HAS_STATS: \u6b63\u3057\u3044\u898b\u7a4d\u306e\u305f\u3081\u306b\u5341\u5206\u306a\u62e1\u5f35\u7d71\u8a08\u304c\u3042\u308b\u3002 PERMANENT: \u898b\u7a4d\u308a\u8aa4\u308a\u304c\u767a\u751f\u3057\u3066\u3044\u308b\u305f\u3081\u3001\u62e1\u5f35\u7d71\u8a08\u306f\u7121\u8996\u3055\u308c\u308b\u3002 12.1.0.2 USABLE: \u30c7\u30a3\u30ec\u30af\u30c6\u30a3\u30d6\u306f\u3042\u308b\u304c\u554f\u984c\u306f\u89e3\u6c7a\u3057\u3066\u3044\u306a\u3044\uff08NEW\u3001MISSING_STATS\u3001PERMANENT\uff09 SUPERSEDED: \u554f\u984c\u306f\u89e3\u6c7a\u6e08\uff08HAS_STAT\u2026","published":"2016-02-21 00:40:37","categories":["Oracle"],"version":"1.0","author_name":"yohei-a","blog_url":"https://yohei-a.hatenablog.jp/","width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20160221%2F1456069237\" title=\"SQL\u8a08\u753b\u30c7\u30a3\u30ec\u30af\u30c6\u30a3\u30d6\u306b\u95a2\u3059\u308b\u30e1\u30e2 - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"SQL\u8a08\u753b\u30c7\u30a3\u30ec\u30af\u30c6\u30a3\u30d6\u306b\u95a2\u3059\u308b\u30e1\u30e2","author_url":"https://blog.hatena.ne.jp/yohei-a/","url":"https://yohei-a.hatenablog.jp/entry/20160221/1456069237","image_url":null,"blog_title":"ablog","type":"rich","provider_url":"https://hatena.blog","height":"190"}