{"height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fgonsuke777.hatenablog.com%2Fentry%2F2022%2F11%2F21%2F225556\" title=\"V$SQL_PLAN \u306e OTHER_XML\u5217 \u306b\u683c\u7d0d\u3055\u308c\u305f XML\u30c7\u30fc\u30bf \u3092\u6574\u5f62\u3057\u3066\u51fa\u529b\u3057\u3066\u307f\u308b(Oracle Database) - \u306d\u3089\uff5eIT\u30a8\u30f3\u30b8\u30cb\u30a2\u96d1\u8a18\" 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%","version":"1.0","type":"rich","provider_name":"Hatena Blog","image_url":null,"author_name":"gonsuke777","url":"https://gonsuke777.hatenablog.com/entry/2022/11/21/225556","provider_url":"https://hatena.blog","categories":["Oracle","Database","\u5b9f\u884c\u8a08\u753b"],"published":"2022-11-21 22:55:56","description":"V$SQL_PLAN \u306f Oracle Database \u306e\u5b9f\u884c\u8a08\u753b\u306b\u95a2\u3059\u308b\u60c5\u5831\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u307e\u3059\u304c\u3001\u8a72\u5f53SQL\u306b\u95a2\u9023\u3059\u308b\u60c5\u5831\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u307e\u3059\u3002 SET LONG 1000000; SET LONGC 1000000; SET LINESIZE 100; COLUMN OTHER_XML_VALUE FORMAT A100; SELECT OTHER_XML FROM V$SQL_PLAN S WHERE S.SQL_ID = 'f9r2y6xdz6t84' AND S.CHILD_NUMBER = 4; OTHER_XML ---------------------------------\u2026","author_url":"https://blog.hatena.ne.jp/gonsuke777/","blog_url":"https://gonsuke777.hatenablog.com/","title":"V$SQL_PLAN \u306e OTHER_XML\u5217 \u306b\u683c\u7d0d\u3055\u308c\u305f XML\u30c7\u30fc\u30bf \u3092\u6574\u5f62\u3057\u3066\u51fa\u529b\u3057\u3066\u307f\u308b(Oracle Database)","blog_title":"\u306d\u3089\uff5eIT\u30a8\u30f3\u30b8\u30cb\u30a2\u96d1\u8a18"}