\uc2e4\uc81c \uc218\ud589 \ub41c SQL PLAN \uc744 trace + tkprof \ub97c \uc218\ud589 \ud558\uc9c0 \uc54a\uace0 \uc2e4\uc2dc\uac04\uc73c\ub85c<\/p>\n
<\/p>\n
\uc744 \ud655\uc778 \ud558\ub294 \ucffc\ub9ac \uc785\ub2c8\ub2e4.<\/p>\n
<\/p>\n
STEP \ubcc4 rows \ub97c \ud655\uc778 \ud558\uae30 \uc704\ud55c \uc120\ud589 \uc791\uc5c5\uc73c\ub85c<\/p>\n
<\/p>\n
STATISTICS_LEVEL<\/pre>\n\u00a0\ud30c\ub77c\ubbf8\ud130\ub97c\u00a0<\/p>\n
ALL<\/pre>\n\ub85c \ubcc0\uacbd \ud569\ub2c8\ub2e4.<\/p>\n
<\/p>\n
\ub610\ub294 \ud788\ub4e0 \ud30c\ub77c\ubbf8\ud130\uc778\u00a0_ROWSOURCE_EXECUTION_STATISTICS \uc758<\/span>\u00a0Parameter \uac12\uc744 TRUE \ub85c \uc124\uc815 \ud569\ub2c8\ub2e4.<\/p>\n
<\/p>\n
\ud544\uc790\ub294 \uc548\uc804\ud558\uac8c \ud6c4\ub2e8\uc744 \uac00\uc774\ub4dc \ud569\ub2c8\ub2e4. (STATISTICS_LEVEL \ud30c\ub77c\ubbf8\ud130 \ubcc0\uacbd \uc2dc SQL PLAN\uc774 \uc545\uc131 \uc73c\ub85c \ubcc0\uacbd \ub420 \uc704\ud5d8\uc774 \uc788\uc2b5\ub2c8\ub2e4)<\/p>\n
<\/p>\n
\uc774\ud6c4 \uc544\ub798\uc758 \ucffc\ub9ac\ub85c \uc2e4\uc2dc\uac04 SQL \uc758 \uc218\ud589 PLAN \ubc0f \ud1b5\uacc4\ub97c \ud655\uc778 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
<\/p>\n
select sum(LAST_ELAPSED_TIME)\/1000000 AS \"elapsed\",\r\n sum(LAST_DISK_READS) AS \"disk\",\r\n sum(LAST_CR_BUFFER_GETS) AS \"query\",\r\n sum(LAST_CU_BUFFER_GETS) AS \"current\",\r\n max(LAST_OUTPUT_ROWS) AS \"rows\"\r\nfrom v$sql_plan_statistics_all\r\nwhere sql_id ='&&sql_id'\r\nand DEPTH=1\r\nand child_number='&&child_number';<\/pre>\n<\/p>\n
\nselect LAST_OUTPUT_ROWS “Row”,
\nLPAD (‘ ‘, DEPTH) || OPERATION ||’ ‘|| OPTIONS ||’ ‘|| OBJECT_NAME || ‘ (cr=’ || LAST_CR_BUFFER_GETS|| ‘ pr=’ || LAST_DISK_READS || ‘ pw=’ || LAST_DISK_WRITES || ‘ time=’ || LAST_ELAPSED_TIME || ‘)’ AS “Row_Source_Operation”
\nfrom v$sql_plan_statistics_all
\nwhere sql_id=’&&sql_id’
\nand child_number=’&&child_number’
\norder by id;<\/p>\n<\/p>\n","protected":false},"excerpt":{"rendered":"
\uc2e4\uc81c \uc218\ud589 \ub41c SQL PLAN \uc744 trace + tkprof \ub97c \uc218\ud589 \ud558\uc9c0 \uc54a\uace0 \uc2e4\uc2dc\uac04\uc73c\ub85c Execution Plan \uc744 \ud655\uc778 \ud558\ub294 \ucffc\ub9ac \uc785\ub2c8\ub2e4. STEP \ubcc4 rows \ub97c \ud655\uc778 \ud558\uae30 \uc704\ud55c \uc120\ud589 \uc791\uc5c5\uc73c\ub85c STATISTICS_LEVEL \u00a0\ud30c\ub77c\ubbf8\ud130\ub97c\u00a0 ALL \ub85c \ubcc0\uacbd \ud569\ub2c8\ub2e4. \ub610\ub294 \ud788\ub4e0 \ud30c\ub77c\ubbf8\ud130\uc778\u00a0_ROWSOURCE_EXECUTION_STATISTICS \uc758\u00a0Parameter \uac12\uc744 TRUE \ub85c \uc124\uc815 \ud569\ub2c8\ub2e4. \ud544\uc790\ub294 \uc548\uc804\ud558\uac8c \ud6c4\ub2e8\uc744 \uac00\uc774\ub4dc \ud569\ub2c8\ub2e4. […]<\/p>\n","protected":false},"author":1,"featured_media":2875,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[1094],"tags":[1099,1098,1097],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/1-know-how.jpg?fit=937%2C450","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3956"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3956"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3956\/revisions"}],"predecessor-version":[{"id":4509,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3956\/revisions\/4509"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2875"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3956"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3956"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3956"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}