{"id":310,"date":"2015-01-21T05:39:34","date_gmt":"2015-01-21T05:39:34","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=310"},"modified":"2015-01-21T05:39:34","modified_gmt":"2015-01-21T05:39:34","slug":"exadata-%ed%99%98%ea%b2%bd%ec%9d%98-sql%ea%b0%9c%eb%b0%9c-%ec%a0%95%ec%b1%85-%ec%88%98%eb%a6%bd-point","status":"publish","type":"post","link":"https:\/\/haisins.synology.me\/wordpress\/?p=310","title":{"rendered":"Exadata \ud658\uacbd\uc758 SQL\uac1c\ubc1c \uc815\ucc45 \uc218\ub9bd POINT"},"content":{"rendered":"<p style=\"text-align: left;\">\n<ul style=\"margin-left: 40pt\">\n<li style=\"text-align: left;\">\n<div><span style=\"color: rgb(0, 112, 192); font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">Exadata\uc758 \ud6a8\uacfc\uc801\uc778 \uae30\ub2a5 \ud65c\uc6a9\ubc29\uc548<br \/>\n<\/span><\/div>\n<ul>\n<li>\n<div><span style=\"color:#0070c0; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong><span style=\"font-size: 10pt;\">Insert \uc704\uc8fc\uc758 \uc791\uc5c5<br \/>\n<\/span><\/strong><\/span><\/div>\n<ul>\n<li><span style=\"color: rgb(0, 112, 192); font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">Update\/Merge \uc704\uc8fc\uc758 \uc791\uc5c5 \ub300\uc2e0 Insert\ub85c \ubcc0\uacbd \uc791\uc5c5<br \/>\n<\/span><\/li>\n<li><span style=\"color: rgb(0, 112, 192); font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">\uc555\ucd95\uae30\uc220\uc758 \ud65c\uc6a9<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"color:#0070c0; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong><span style=\"font-size: 10pt;\">Exadata\uc5d0\uc11c\ub3c4 Index\ub294 \ud544\uc694\ud568.<br \/>\n<\/span><\/strong><\/span><\/div>\n<ul>\n<li><span style=\"color: rgb(0, 112, 192); font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">S\uc0ac\uc758 \uacbd\uc6b0 ODS\ub294 PK\ub9cc \uc0dd\uc131, Mart\ub294 Index\uc5c6\uc774 \uc6b4\uc601<br \/>\n<\/span><\/li>\n<li><span style=\"color: rgb(0, 112, 192); font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">\uae30\uc874\uc758 Index\uc5d0 \ub300\ud55c \uac1c\ub150\uc774 \ubc14\ub00c\uc5b4\uc57c \ud568.<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"color:#0070c0; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong><span style=\"font-size: 10pt;\">Parallel \ucc98\ub9ac\uc2dc \uc2dc\uc2a4\ud15c \ubd80\ud558 \ubc29\uc9c0\ub97c \uc704\ud55c \uc801\uc808\ud55c Hint \uc0ac\uc6a9<br \/>\n<\/span><\/strong><\/span><\/div>\n<ul>\n<li><span style=\"color: rgb(0, 112, 192); font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">Hint\ub85c \uc27d\uac8c \uc81c\uc5b4 \uac00\ub2a5\ud568.<br \/>\n<\/span><\/li>\n<li><span style=\"color: rgb(0, 112, 192); font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">Resource Manager\ub97c \ud1b5\ud55c \uad00\ub9ac\uac00 \ud544\uc694\ud568.<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"color:#0070c0; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong><span style=\"font-size: 10pt;\">Partition Exchange\uc744 \ud65c\uc6a9\ud574\uc57c \ud568.<br \/>\n<\/span><\/strong><\/span><\/div>\n<ul>\n<li><span style=\"color: rgb(0, 112, 192); font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">Index\uc5d0 \uc758\ud55c Overhead \uac10\uc18c \ubc0f \uc555\ucd95\uc744 \uc720\uc9c0\ud574\uc57c \ud568.<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"color:#0070c0; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong><span style=\"font-size: 10pt;\">Exadata\uc5d0\uc11c \ud1b5\uacc4\uc815\ubcf4\ub294 \ud544\uc218 \uc784.<br \/>\n<\/span><\/strong><\/span><\/div>\n<ul>\n<li><span style=\"color: rgb(0, 112, 192); font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">Exadata\uc758 \ub2e4\uc591\ud55c \uae30\ub2a5\ud65c\uc6a9\uc758 \ub9ce\uc740 \ubd80\ubd84\uc740 \ud1b5\uacc4\uc815\ubcf4\uc5d0 \uae30\ubc18\ud568.<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"color:#0070c0; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong><span style=\"font-size: 10pt;\">Bulk \ucc98\ub9ac\uac00 \uc548\ub418\ub294 SQL\ubb38\uc758 \uad6c\ud604\uc744 \ud53c\ud574\uc57c \ud568.<br \/>\n<\/span><\/strong><\/span><\/div>\n<ul>\n<li><span style=\"color: rgb(0, 112, 192); font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">\ub300\uc6a9\ub7c9 \ub370\uc774\ud130\uc758 \uac74\ub2e8\uc704 \uc218\ud589<br \/>\n<\/span><\/li>\n<li>\n<div><span style=\"color:#0070c0; font-family:\ub9d1\uc740 \uace0\ub515\"><span style=\"font-size: 10pt;\">\ud544\uc694\uc5d0 \ub530\ub77c\uc11c \uc0dd\uc131\ub418\uace0, \uae30\uc874 \ubd80\uc801\uc808\ud55c \ubaa8\ub378\uae30\ubc18 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ubcc0\uacbd \uc5c6\ub294 \uc218\uc6a9<\/span><span style=\"font-size: 10pt;\"><br \/>\n\t\t\t\t\t\t\t\t\t<\/span><\/span><\/div>\n<p><span style=\"font-size: 10pt;\"><br \/>\n&nbsp;<\/span><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li style=\"text-align: left;\">\n<div><span style=\"color: red; font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">Exadata\uc5d0\uc11c \ud558\uc9c0 \ub9d0\uc544\uc57c \ud560 \uac83<br \/>\n<\/span><\/div>\n<ul>\n<li>\n<div><span style=\"color:red; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong><span style=\"font-size: 10pt;\">Sort &amp; Hash area size\uc758 \uc784\uc758 \uc870\uc815<br \/>\n<\/span><\/strong><\/span><\/div>\n<ul>\n<li><span style=\"color: red; font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">Sort area, hash area size\ub97c \uc784\uc758\ub85c \uc870\uc815\ud558\ub294 \uac83\uc740 \uc804\uccb4 \uc2dc\uc2a4\ud15c\uc5d0 \uc601\ud5a5\uc744 \uc8fc\uae30 \ub54c\ubb38\uc5d0 Session\ub2e8\uc704\ub85c \ubcc0\uacbd\ud558\uba74\uc11c \uc218\ud589\ud558\uc9c0 \ub9d0\uc544\uc57c \ud568.<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"color:red; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong><span style=\"font-size: 10pt;\">Parallel\uc758 Default \uc0ac\uc6a9 \ud639\uc740 \uacfc\ub2e4\ud55c parallel\uc758 \uc0ac\uc6a9<br \/>\n<\/span><\/strong><\/span><\/div>\n<ul>\n<li><span style=\"color: red; font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">Parallel Default\ub294 MAX\uc784\uc73c\ub85c \ubc18\ub4dc\uc2dc \uc8fc\uc758\ud574\uc57c \ud568.<br \/>\n<\/span><\/li>\n<li><span style=\"color: red; font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">Parallel degree \uc870\uc815\uc774 Plan\uc758 \ubcc0\uacbd\uc744 \uac00\uc9c0\uace0 \uc634\uc73c\ub85c \uc8fc\uc758\ud574\uc57c \ud568.<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"color:red; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong><span style=\"font-size: 10pt;\">Global index \uc0dd\uc131 \ubc0f \uc120\ud0dd\uc131\uc774 \ub0ae\uc740 Index\uc758 \uc0dd\uc131<br \/>\n<\/span><\/strong><\/span><\/div>\n<ul>\n<li><span style=\"color: red; font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">\ud2b9\uc218\ud55c \uacbd\uc6b0\uac00 \uc544\ub2c8\uba74 \ucd5c\uc18c\ud654\ud574\uc57c \ud568.<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"color:red; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong><span style=\"font-size: 10pt;\">\ud1b5\uacc4\uc815\ubcf4 \ubd80\uc871\uc744 Hint\ub85c \ud574\uacb0\ud558\ub294 \uacbd\uc6b0<br \/>\n<\/span><\/strong><\/span><\/div>\n<ul>\n<li><span style=\"color: red; font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">Ordered \uc640 \uac19\uc740 Hint\ub294 \uc798\ubabb\ub41c Plan\uc744 \ub9cc\ub4e4\uc5b4 \ub0bc \uc218 \uc788\uc74c. Full, use_hash \uc704\uc8fc\ub85c Hint \ubd80\uc5ec<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"color:red; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong><span style=\"font-size: 10pt;\">Conventional path \ubcf4\ub2e4 Direct read\/write\uc758 \ud65c\uc6a9<br \/>\n<\/span><\/strong><\/span><\/div>\n<ul>\n<li><span style=\"color: red; font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">Conventional write\uac00 \ubc1c\uc0dd\ud558\uba74 Direct read\uc2dc Buffer\uc758 data\ub97c Disk\ub85c Write\ud55c \ud6c4\uc5d0 Query\uac00 \uac00\ub2a5\ud558\uae30 \ub54c\ubb38\uc5d0 \ud14c\uc774\ube14\uc758 \uc131\uaca9\uc5d0 \ub530\ub77c \uc870\uc815\ud574\uc57c \ud568.<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"color:red; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong><span style=\"font-size: 10pt;\">Temporary table \uacfc\ub2e4 \uc0ac\uc6a9<br \/>\n<\/span><\/strong><\/span><\/div>\n<ul>\n<li><span style=\"color: red; font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt;\">Temporary table\uc740 parallel \ucc98\ub9ac\uac00 \uc548\ub418\uae30 \ub54c\ubb38\uc5d0 With\uc808\uc744 \uc0ac\uc6a9\ud558\uac70\ub098 Real table\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc744 \uad8c\uace0\ud568. (Temporary Table \uc0ac\uc6a9\uc2dc \uc8fc\uc758)<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Exadata\uc758 \ud6a8\uacfc\uc801\uc778 \uae30\ub2a5 \ud65c\uc6a9\ubc29\uc548 Insert \uc704\uc8fc\uc758 \uc791\uc5c5 Update\/Merge \uc704\uc8fc\uc758 \uc791\uc5c5 \ub300\uc2e0 Insert\ub85c \ubcc0\uacbd \uc791\uc5c5 \uc555\ucd95\uae30\uc220\uc758 \ud65c\uc6a9 Exadata\uc5d0\uc11c\ub3c4 Index\ub294 \ud544\uc694\ud568. S\uc0ac\uc758 \uacbd\uc6b0 ODS\ub294 PK\ub9cc \uc0dd\uc131, Mart\ub294 Index\uc5c6\uc774 \uc6b4\uc601 \uae30\uc874\uc758 Index\uc5d0 \ub300\ud55c \uac1c\ub150\uc774 \ubc14\ub00c\uc5b4\uc57c \ud568. Parallel \ucc98\ub9ac\uc2dc \uc2dc\uc2a4\ud15c \ubd80\ud558 \ubc29\uc9c0\ub97c \uc704\ud55c \uc801\uc808\ud55c Hint \uc0ac\uc6a9 Hint\ub85c \uc27d\uac8c \uc81c\uc5b4 \uac00\ub2a5\ud568. Resource Manager\ub97c \ud1b5\ud55c \uad00\ub9ac\uac00 \ud544\uc694\ud568. Partition Exchange\uc744 \ud65c\uc6a9\ud574\uc57c \ud568. [&hellip;]<\/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,28,29,30],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/310"}],"collection":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=310"}],"version-history":[{"count":0,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/310\/revisions"}],"wp:attachment":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=310"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}