{"id":404,"date":"2024-12-13T16:21:01","date_gmt":"2024-12-13T07:21:01","guid":{"rendered":"https:\/\/sejiwon.com\/?p=404"},"modified":"2024-12-13T16:21:01","modified_gmt":"2024-12-13T07:21:01","slug":"query-%ec%86%8d%eb%8f%84%ed%99%95%ec%9d%b8","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=404","title":{"rendered":"Query \uc18d\ub3c4\ud655\uc778"},"content":{"rendered":"\n<p>\uba3c\uc800, \ub300\uc0c1\uc774 \ub418\ub294 \ucffc\ub9ac\uc5d0 \/* &#8230; *\/ \uc8fc\uc11d\ubb38 \uc548\uc5d0 sql_id\ub97c \uc27d\uac8c \ucc3e\uc744 \uc218 \uc788\ub3c4\ub85d \uc8fc\uc11d\uc744 \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\n  FROM v$sql a\n WHERE a.sql_text LIKE '%\uc8fc\uc11d\ub0b4\uc6a9%'\n;<\/code><\/pre>\n\n\n\n<p>\uc774 \ub2e4\uc74c\uc5d0 DBMS_XPLAN\uc744 \uc774\uc6a9\ud558\uc5ec \ub0b4\uc6a9\uc744 \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\n  FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR('sql_id', NULL, 'TYPICAL'));\n<\/code><\/pre>\n\n\n\n<p>TYPICAL\uc790\ub9ac\uc5d0\ub294 &#8216;ADVANCED ALLSTATS LAST&#8217; \ub610\ub294 &#8216;ALLSTATS LAST&#8217; \ubc0f &#8216;PARTITION&#8217; \ub4f1\uc73c\ub85c \ub300\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uba3c\uc800, \ub300\uc0c1\uc774 \ub418\ub294 \ucffc\ub9ac\uc5d0 \/* &#8230; *\/ \uc8fc\uc11d\ubb38 \uc548\uc5d0 sql_id\ub97c \uc27d\uac8c \ucc3e\uc744 \uc218 \uc788\ub3c4\ub85d \uc8fc\uc11d\uc744 \uc785\ub825\ud569\ub2c8\ub2e4. \uc774 \ub2e4\uc74c\uc5d0 DBMS_XPLAN\uc744 \uc774\uc6a9\ud558\uc5ec \ub0b4\uc6a9\uc744 \ud655\uc778\ud569\ub2c8\ub2e4. TYPICAL\uc790\ub9ac\uc5d0\ub294 &#8216;ADVANCED ALLSTATS LAST&#8217; \ub610\ub294 &#8216;ALLSTATS LAST&#8217; \ubc0f &#8216;PARTITION&#8217; \ub4f1\uc73c\ub85c \ub300\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/404"}],"collection":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=404"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/404\/revisions"}],"predecessor-version":[{"id":405,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/404\/revisions\/405"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=404"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}