{"id":655,"date":"2015-11-19T00:49:09","date_gmt":"2015-11-19T00:49:09","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=655"},"modified":"2015-11-19T00:49:09","modified_gmt":"2015-11-19T00:49:09","slug":"exadata-%ed%99%98%ea%b2%bd%ec%97%90%ec%84%9c-%ec%95%85%ec%84%b1-sql-%eb%82%98%ed%83%80%eb%82%a0-%ec%88%98-%ec%9e%88%eb%8a%94-%ec%a1%b0%ea%b1%b4","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=655","title":{"rendered":"EXADATA \ud658\uacbd\uc5d0\uc11c \uc545\uc131 SQL \ub098\ud0c0\ub0a0 \uc218 \uc788\ub294 \uc870\uac74"},"content":{"rendered":"

EXADATA \ud658\uacbd\uc5d0\uc11c \uc545\uc131 SQL \ub098\ud0c0\ub0a0 \uc218 \uc788\ub294 \uc870\uac74<\/p>\n

<\/p>\n

1. With\uc808 , Inlive View\uc758 \uc911\ucca9 \uad6c\ubb38 \uc0ac\uc6a9\uc5d0 \ub530\ub978 \ubd80\uc791\uc6a9 \ubc1c\uc0dd<\/p>\n

\t<\/span>– \uc911\ubcf5 I\/O\uac00 \ubc1c\uc0dd<\/p>\n

\t<\/span>– View \uc0ac\uc6a9\uc5d0 \ub530\ub978 Rewrite Overhead \ubc0f View Merge\ub4f1 \uc131\ub2a5\uc5d0 \ub9e4\uc6b0 \ubd88\ub9ac<\/p>\n

\t<\/span>– \ud544\uc694 \uc2dc, \uc911\uac04 \uc9d1\uacc4 \ub610\ub294 \ubaa8\uc9d1\ub2e8 \uc784\uc2dc TABLE \uc0dd\uc131\uc744 \ud1b5\ud574 \uc2e4\uccb4\ud654\ub41c Segment(TABLE)\uc5d0\uc11c I\/O \uc218\ud589 \uc720\ub3c4<\/p>\n

\t<\/span><\/p>\n

2. \uc778\ub371\uc2a4\uac00 \uc874\uc7ac\ud558\ub294 \ub300\uc6a9\ub7c9 Table \uc870\uc778\uc2dc \ud78c\ud2b8\ub85c \uc81c\uc5b4\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0<\/p>\n

\t<\/span>– Full, Parallel\ub4f1\uc758 Hint \uc81c\uc5b4\ub97c \ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0 Plan\uc774 \ubcc0\uacbd\ub418\uc5b4 \ucc98\ub9ac \uc9c0\uc5f0 \ubc1c\uc0dd<\/p>\n

\t<\/span>– \uc774\ub85c \uc778\ud574 Hash Join \ud615\ud0dc\uac00 \ucd5c\uc120\uc778 \uc0c1\ud0dc\uc5d0\uc11c Nested Loop Join\uc73c\ub85c Plan\uc774 \ubcc0\uacbd\ub420 \ud655\ub960\uc774 \ub192\uc74c<\/p>\n

\t<\/span><\/p>\n

3. \uc6d0\uc7a5 \ub370\uc774\ud130 \ubcc0\uacbd \uc801\uc7ac\uc2dc \ubcc0\uacbd \ubd84\uc774 15%\ub97c \ucd08\uacfc\ud560 \uacbd\uc6b0(\uc77c\ubc18\uc801\uc778 \uacbd\uc6b0 3\uc5b5\uac74 \uc774\ub0b4\uc784)<\/p>\n

\t<\/span>– DML \uc591\uc774 \ub9ce\uc544 \uc9c8\uc218\ub85d GC,Buffer Busy Waits  event\ub4f1 \ub3d9\uc2dc\uc131, \ud074\ub7ec\uc2a4\ud130 \uad00\ub828 \uc774\ubca4\ud2b8\uac00 \ub9ce\uc544\uc9c0\uba70, \uc2dc\uc2a4\ud15c\uc774 \uc810\uc810 \ub290\ub824\uc9c0\uac8c \ub428<\/p>\n

\t<\/span>– Insert Append \ubc29\uc2dd\uc73c\ub85c \ucc98\ub9ac \uad8c\uc7a5<\/p>\n

\t<\/span><\/p>\n

4. \ubb34\ubd84\ubcc4\ud55c \ud78c\ud2b8 \uc0ac\uc6a9<\/p>\n

\t<\/span>– \uc815\ud655\ud55c \ud1b5\uacc4\uac00 \uc804\uc81c\ub418\ub294 \ud55c \ubd88\ud544\uc694\ud55c \ud78c\ud2b8\ub97c \uc8fc\uc9c0 \uc54a\ub294 \uac83\uc774 \uad00\ub9ac\uc5d0 \uc720\ub9ac<\/p>\n

<\/p>\n

5. \ubcc0\uacbd \uc801\uc7ac \uc2dc Index\ub97c \uc0ac\uc6a9\ud55c \uc815\ud569\uc131 Check<\/p>\n

\t<\/span>– PK \uc0dd\uc131\ub41c \ud14c\uc774\ube14\uc5d0 Data\ub97c \uc785\ub825\ud560 \uacbd\uc6b0 Single Block I\/O, Buffer Busy, Index Maintenance, gc event \ubc1c\uc0dd \ub4f1\uc73c\ub85c \ucc98\ub9ac\uac00 \uc9c0\uc5f0<\/p>\n

\t<\/span>– \uc911\ubcf5 \ubc1c\uc0dd\uc2dc \uc815\ud569\uc131 \uccb4\ud06c \ud6c4 \uc7ac \uc791\uc5c5\uc744 \ud574\uc57c \ud568.<\/p>\n","protected":false},"excerpt":{"rendered":"

EXADATA \ud658\uacbd\uc5d0\uc11c \uc545\uc131 SQL \ub098\ud0c0\ub0a0 \uc218 \uc788\ub294 \uc870\uac74 1. With\uc808 , Inlive View\uc758 \uc911\ucca9 \uad6c\ubb38 \uc0ac\uc6a9\uc5d0 \ub530\ub978 \ubd80\uc791\uc6a9 \ubc1c\uc0dd – \uc911\ubcf5 I\/O\uac00 \ubc1c\uc0dd – View \uc0ac\uc6a9\uc5d0 \ub530\ub978 Rewrite Overhead \ubc0f View Merge\ub4f1 \uc131\ub2a5\uc5d0 \ub9e4\uc6b0 \ubd88\ub9ac – \ud544\uc694 \uc2dc, \uc911\uac04 \uc9d1\uacc4 \ub610\ub294 \ubaa8\uc9d1\ub2e8 \uc784\uc2dc TABLE \uc0dd\uc131\uc744 \ud1b5\ud574 \uc2e4\uccb4\ud654\ub41c Segment(TABLE)\uc5d0\uc11c I\/O \uc218\ud589 \uc720\ub3c4 2. \uc778\ub371\uc2a4\uac00 \uc874\uc7ac\ud558\ub294 \ub300\uc6a9\ub7c9 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[25],"tags":[27,320,321,29,322],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/655"}],"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=655"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/655\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=655"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}