{"height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fharadago.hatenadiary.org%2Fentry%2F20090324%2Fp1\" title=\"\u52d5\u7684\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30d3\u30e5\u30fc - \u3076\u308a\u308a\u3042\u3093\u3068\u308d\u30fc\u3069(\u4eee)\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","type":"rich","blog_url":"https://haradago.hatenadiary.org/","version":"1.0","author_name":"haradago","provider_name":"Hatena Blog","description":"V$SQL,V$SQL_TEXT,V$SQL_PLAN\u3002 \u73fe\u5728\u5171\u6709SQL\u9818\u57df\u306b\u30ad\u30e3\u30c3\u30b7\u30e5\u3055\u308c\u3066\u3044\u308bSQL\u306e\u60c5\u5831\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u3002 \u3053\u308c\u3089\u3092\u7528\u3044\u3066\u3001\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u304c\u53ef\u80fd\u3002 1.V$SQL\u3067\u8abf\u67fb\u3057\u305f\u3044SQL\u306eSQLID\u3092\u8abf\u3079\u308b SELECT * FROM V$SQL WHERE SQL_TEXT LIKE '%HOGE_TBL%' 2.EnterPrise Manager DataBaseConsole\u304b\u3089GUI\u3067\u5b9f\u884c\u8a08\u753b\u3092\u8abf\u3079\u308b 2-1.EnterPrise Manager\u306e\u300c\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u300d\u30bf\u30d6\u300c\u30c8\u30c3\u30d7\u30a2\u30af\u30c6\u30a3\u30d3\u30c6\u30a3\u300d\u3092\u30af\u30ea\u30c3\u30af 2-2.\u4e0a\u4f4dSQL\u3067\u9069\u5f53\u306aSQL\u3092\u30af\u30ea\u30c3\u30af 2-3.\u753b\u9762\u4e0a\u90e8\u306e\u300cS\u2026","author_url":"https://blog.hatena.ne.jp/haradago/","blog_title":"\u3076\u308a\u308a\u3042\u3093\u3068\u308d\u30fc\u3069(\u4eee)","width":"100%","provider_url":"https://hatena.blog","title":"\u52d5\u7684\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30d3\u30e5\u30fc","image_url":null,"url":"https://haradago.hatenadiary.org/entry/20090324/p1","published":"2009-03-24 00:00:00","categories":["oracle","\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0"]}