{"author_name":"yohei-a","type":"rich","title":"\u5b9f\u884c\u8a08\u753b\u304c\u5909\u52d5\u3057\u305fSQL\u306e\u5b9f\u884c\u8a08\u753b\u3092\u4e00\u62ec\u51fa\u529b\u3059\u308b","height":"190","author_url":"https://blog.hatena.ne.jp/yohei-a/","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20150705%2F1436102030\" title=\"\u5b9f\u884c\u8a08\u753b\u304c\u5909\u52d5\u3057\u305fSQL\u306e\u5b9f\u884c\u8a08\u753b\u3092\u4e00\u62ec\u51fa\u529b\u3059\u308b - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","width":"100%","blog_title":"ablog","blog_url":"https://yohei-a.hatenablog.jp/","image_url":null,"provider_url":"https://hatena.blog","published":"2015-07-05 22:13:50","version":"1.0","categories":["Oracle"],"url":"https://yohei-a.hatenablog.jp/entry/20150705/1436102030","description":"DBA_HIST_SQL_PLAN \u306b PLAN_HASH_VALUE \u304c\u8907\u6570\u3042\u308b SQL \u306e\u5b9f\u884c\u8a08\u753b\u3092 DBMS_XPLAN.DISPLAY_AWR \u3067\u4e00\u62ec\u51fa\u529b\u3059\u308b SQL\u3002\u518d\u5e30SQL\u304c\u51fa\u529b\u3055\u308c\u306a\u3044\u3088\u3046 OBJECT_OWNER \u3067\u7d5e\u3063\u3066\u3044\u308b\u3002 SQL set pagesize 50000 set linesize 200 select b.* from ( select distinct sql_id from ( select p.sql_id, count(distinct p.plan_hash_value) over(partition by p.sql_id) as cnt fr\u2026"}