{"id":388,"date":"2015-06-29T02:28:13","date_gmt":"2015-06-29T02:28:13","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=388"},"modified":"2015-06-29T02:28:13","modified_gmt":"2015-06-29T02:28:13","slug":"sql%eb%a1%9c%eb%8d%94-%ec%82%ac%ec%9a%a9%ec%8b%9c-%ec%84%b1%eb%8a%a5-%ed%96%a5%ec%83%81-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=388","title":{"rendered":"SQL\ub85c\ub354 \uc0ac\uc6a9\uc2dc \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95"},"content":{"rendered":"

\ubaa8 \uace0\uac1d\uc0ac\uc5d0\uc11c \uc544\ub798\uc640 \uac19\uc740 \ubb38\uc758\uc0ac\ud56d\uc774 \uc788\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

<\/p>\n

# <\/span>\uae30\uc874<\/span> <\/span>\uc2a4\ud06c\ub9bd\ud2b8<\/span><\/p>\n

1<\/span>\ubc88<\/span> : sql<\/span>ldr userid=scott\/tiger control=abc.ctl errors=999999999
\nREADSIZE=3145728 BINDSIZE=3145728 ROWS=5000<\/span><\/p>\n

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

# <\/span>\ubcc0\uacbd<\/span> <\/span>\uc2a4\ud06c\ub9bd\ud2b8<\/span><\/p>\n

2<\/span>\ubc88<\/span> : sql<\/span>ldr userid=scott\/tiger control=abc.ctl errors=999999999
\nREADSIZE=20000000 BINDSIZE=20000000 ROWS=5000<\/span><\/p>\n

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

# <\/span>\ubb38\uc758\uc0ac\ud56d<\/span><\/p>\n

<\/p>\n

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

    \n
  1. rows <\/span>\uac12\uc744<\/span> 5000<\/span>\uc744<\/span> <\/span>\uc8fc\uc5c8\ub294\ub370<\/span> <\/span>\uc77c\uc815\ud558\uac8c<\/span> commit<\/span>\uc774<\/span> <\/span>\ub418\uc9c0<\/span> <\/span>\uc54a\ub294<\/span> <\/span>\ud604\uc0c1<\/span> – <\/span>\ub0b4\ubd80\uc5d0\uc11c<\/span> <\/span>\ud14c\uc2a4\ud2b8\uc2dc<\/span> 1<\/span>\ubc88<\/span> <\/span>\uc2a4\ud06c\ub9bd\ud2b8\ub85c<\/span> <\/span>\ub3cc\ub838\uc744<\/span> <\/span>\ub54c<\/span> commit<\/span>\uc774<\/span> 4053 <\/span>\ub2e8\uc704\ub85c<\/span> <\/span>\ucc0d\ud614\uc2b5\ub2c8\ub2e4<\/span>. <\/span>\uadf8\ub9ac\uace0<\/span> 2<\/span>\ubc88\uc73c\ub85c<\/span> <\/span>\ub3cc\ub838\uc744<\/span> <\/span>\ub54c\ub294<\/span> 5000<\/span>\uc73c\ub85c<\/span> <\/span>\uade0\uc77c\ud558\uac8c<\/span> commit<\/span>\uc774<\/span> <\/span>\ub418\uc5c8\ub294\ub370<\/span> <\/span>\uc774\ub294<\/span> READSIZE(buffer)<\/span>\uc5d0<\/span> <\/span>\ub530\ub978<\/span> <\/span>\ucc28\uc774\ub85c<\/span> <\/span>\ubcf4\uc785\ub2c8\ub2e4<\/span>. READISZE<\/span>\ub294<\/span> MAX<\/span>\uac12\uc774<\/span> <\/span>20971520<\/span>(20MB) <\/span>\uc785\ub2c8\ub2e4<\/span>.<\/span><\/li>\n
  2. \ub808\ucf54\ub4dc<\/span> <\/span>\uae38\uc774\uc5d0<\/span> <\/span>\ub530\ub978<\/span> readsize,
    \n bindsize<\/span>\uc758<\/span> <\/span>\uc801\uc815\uc0ac\uc774\uc988<\/span> <\/span>\uacc4\uc0b0\ubc29\ubc95<\/span> – <\/span>\uc801\uc815\uc0ac\uc774\uc988<\/span> <\/span>\uacc4\uc0b0\ubc29\ubc95\uc73c\ub85c<\/span> ORACLE<\/span>\uc5d0\uc11c<\/span> <\/span>\uad8c\uc7a5\ud558\uace0<\/span> <\/span>\uc788\ub294<\/span> <\/span>\ubc29\ubc95\uc740<\/span> <\/span>\uc5c6\uc2b5\ub2c8\ub2e4<\/span>. <\/span>\ud604\uc7ac<\/span> <\/span>\uc0c1\ud669\uc5d0\uc11c\ub294<\/span> <\/span>\uc704\uc5d0\uc11c<\/span> <\/span>\uac00\uc774\ub4dc\ud55c<\/span> READSIZE MAX<\/span>\uac12\uc744<\/span> <\/span>\uc8fc\uace0<\/span> <\/span>\ud14c\uc2a4\ud2b8\ud558\uace0<\/span> <\/span>\ubd80\ud558\uac00<\/span> <\/span>\ub9ce\uc744<\/span> <\/span>\uc2dc<\/span> <\/span>\uc810\ucc28<\/span> <\/span>\uac12\uc744<\/span> <\/span>\uc904\uc5ec\ub098\uac00\ub294<\/span> <\/span>\ubc29\ubc95\uc73c\ub85c<\/span> <\/span>\uac12\uc744<\/span> <\/span>\ucc3e\uc544\uc57c<\/span> <\/span>\ud569\ub2c8\ub2e4<\/span>. <\/span>\uadf8\ub9ac\uace0<\/span> READSIZE<\/span>\uc640<\/span> BINDSIZE <\/span>\uac12\uc740<\/span> <\/span>\uac19\uac8c<\/span> <\/span>\uc8fc\ub294<\/span> <\/span>\uac83\uc744<\/span> <\/span>\uad8c\uc7a5\ud569\ub2c8\ub2e4<\/span>.<\/span><\/li>\n<\/ol>\n

    <\/p>\n

    SQL\ub85c\ub354\ub85c \ub370\uc774\ud130\ub97c \ub123\uc744\uc2dc\uc5d0 \uc7a6\uc740 commit\uc740 \ubc00\uc5b4 \ub123\ub294\ub370\uc5d0 \uc18d\ub3c4\uac00 \ub290\ub824\uc9c0\uac8c \ub429\ub2c8\ub2e4. \uc774\ub97c \uc904\uc774\uae30 \uc704\ud574 ROWS\ub97c 5000\uc744 \uc8fc\uc5b4 commit\uc744 \ud558\uac8c \ud588\ub294\ub370, 5000\uc5d0 \ub9de\uac8c commit\uc774 \ub418\uc9c0 \uc54a\uace0 4053\uc5d0 commit\uc774 \ub418\uace0 \uc788\uc5c8\uc2b5\ub2c8\ub2e4. \ub0b4\ubd80 \ud14c\uc2a4\ud2b8 \uacb0\uacfc \uc774\ub294 READSIZE(buffer) \uc9c0\uc815 \uac12\uc758 \ubb38\uc81c\ub85c \ucd5c\ub300\uac12\uc744 \uc8fc\uc5b4 \ud574\uacb0\uc774 \uac00\ub2a5\ud588\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

    \uc6b4\uc601DB\uc5d0 SQL\ub85c\ub354\ub97c \uc774\uc6a9\ud558\uc5ec \ubc00\uc5b4\ub123\ub294 \uacbd\uc6b0\uc5d0\ub294. \uc11c\ubc84\uc758 Resource \uc0ac\uc6a9\uc728\uc744 \uace0\ub824\ud558\uace0 \ucd5c\ub300\ud55c \ubd80\ud558\ub97c \uc801\uac8c\ud558\uc5ec \uc11c\ube44\uc2a4\uc5d0 \uc601\ud5a5\uc774 \uac00\uc9c0 \uc54a\uac8c \ud574\uc57c\ub418\ub294 \uac83\uc774 \ud3ec\uc778\ud2b8 \uc785\ub2c8\ub2e4.<\/span><\/p>\n

    \uc774\ub294 \uc2e4\uc81c \uc6b4\uc601DB\uc640 \uac19\uc740 \ud658\uacbd\uc5d0\uc11c \uc704 \uad6c\ubb38\uc5d0\uc11c \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 \uc218\uce58\ub97c \uc815\ud558\uae30 \uc704\ud558\uc5ec \ub9ce\uc740 \ud14c\uc2a4\ud2b8\ub97c \ud574\ubd10\uc57c \ud55c\ub2e4\ub294 \uac83 \uc785\ub2c8\ub2e4. <\/span><\/p>\n

    <\/p>\n

    \uc544\ub798\ub294 SQL\ub85c\ub354 \uc0ac\uc6a9\uc2dc \uc131\ub2a5 \ud5a5\uc0c1\uc5d0 \ub300\ud55c \ubc29\ubc95\uc785\ub2c8\ub2e4. \ucc38\uace0 \ud558\uc5ec \uc218\ud589\ud558\uc2dc\uba74 \uc88b\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

    – \uc81c\uc5b4\ud30c\uc77c\uacfc \ub370\uc774\ud130
    \n\ud30c\uc77c\uc744 \ubd84\ub9ac\ud558\uba74 \uc5ec\ub7ec \ub85c\ub4dc \uc138\uc158\uc5d0\uc11c \uc81c\uc5b4 \ud30c\uc77c\uc744 \ub2e4\uc2dc \uc0ac\uc6a9 \ud560 \uc218 \uc788\ub2e4.<\/span><\/p>\n

    – \uc608\uc0c1\ub418\ub294 \ub370\uc774\ud130
    \n\ubcfc\ub968\uc744 \uae30\ubc18\uc73c\ub85c \uacf5\uac04\uc744 \ubbf8\ub9ac \ud560\ub2f9\ud558\uba74 \ub85c\ub4dc \uc2dc \ud655\uc7a5 \uc601\uc5ed\uc758 \ub3d9\uc801 \ud560\ub2f9\uc744 <\/span>\ubc29\uc9c0\ud558\uc5ec \ub85c\ub4dc \uc18d\ub3c4\uac00
    \n\ud5a5\uc0c1\ub41c\ub2e4.<\/span><\/p>\n

    – \ud14c\uc774\ube14\uc5d0 \uc778\ub371\uc2a4\uac00
    \n\uac78\ub824\uc788\uc744 \uacbd\uc6b0, \uba3c\uc800 \uc778\ub371\uc2a4\ub97c drop \uc2dc\ud0a4\uace0 SQL Loader \ub85c \ub370\uc774\ud130\ub97c \uc62c\ub9b0 <\/span>\ud6c4 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud55c\ub2e4.<\/span><\/p>\n

    – \ub370\uc774\ud130\uc758 \uc591\uc774 \ub9ce\uc744
    \n\uacbd\uc6b0 Redo log size \ub97c \ucda9\ubd84\ud788 \ud06c\uac8c \uc124\uc815\ud55c\ub2e4. Redo log size \uac00 \uc791\uc744 \uacbd\uc6b0 <\/span>Redo log
    \nswitch \ud560 \ub54c \ub9c8\ub2e4 LGWR \uc5d0\uc11c timeout \uc774 \ubc1c\uc0dd\ud558\uc5ec SQL Loader \uc5d0\uc11c hang \ud604\uc0c1\uc774 <\/span>\ubc1c\uc0dd \ud560 \uc218 \uc788\ub2e4.<\/span><\/p>\n

    – \ub370\uc774\ud130\ub97c \ub85c\ub529\ud558\uae30
    \n\uc804 \ub370\uc774\ud130\ub97c \uc0ad\uc81c \ud6c4 \ub85c\ub529\ud558\uae30 \uc704\ud574\uc11c\ub294 REPLACE \uc635\uc158 \ub300\uc2e0 TRUNCATE <\/span>\uc635\uc158\uc744 \uc0ac\uc6a9\ud55c\ub2e4.
    \nREPLACE \uc635\uc158\uc740 redo log \ubc0f rollback \ub370\uc774\ud130\uac00 \ubc1c\uc0dd\ud558\uac8c \ub418\uc9c0\ub9cc <\/span>TRUNCATE \uc635\uc158\uc740
    \n\uadf8\ub807\uc9c0 \uc54a\ub2e4.<\/span><\/p>\n

    – Commit \ubb38\uc758
    \n\uc2e4\ud589\uc744 \uc790\uc8fc \ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0 SQL Loader \uac00 \ubcf4\ub2e4 \ub354 \ube68\ub9ac \uc2e4\ud589\ub41c\ub2e4<\/span><\/p>\n

    – DIRECT PATH \uc635\uc158\uc744 \uc0ac\uc6a9\uba74 \ub370\uc774\ud130\uac00 <\/span>DB Buffer Cache<\/span> \uc744 \uac70\uce58\uc9c0 \uc54a\uace0 \ubc14\ub85c \ub370\uc774\ud130\ud30c\uc77c\uc5d0 write <\/span>\ub428\uc73c\ub85c \uc18d\ub3c4\uac00
    \n\ube68\ub77c\uc9c4\ub2e4.<\/span><\/p>\n

    – PARALLERL
    \n\uc635\uc158\uc744 \uc0ac\uc6a9\ud55c\ub2e4. \ub2e4\uc911 SQL Loader \uc138\uc158\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \ud55c \uac1c\uc758 \ud14c\uc774\ube14\ub3c4 <\/span>parallel \ud558\uac8c
    \nloading \ub420 \uc218 \uc788\ub2e4.<\/span><\/p>\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    \ubaa8 \uace0\uac1d\uc0ac\uc5d0\uc11c \uc544\ub798\uc640 \uac19\uc740 \ubb38\uc758\uc0ac\ud56d\uc774 \uc788\uc5c8\uc2b5\ub2c8\ub2e4. # \uae30\uc874 \uc2a4\ud06c\ub9bd\ud2b8 1\ubc88 : sqlldr userid=scott\/tiger control=abc.ctl errors=999999999 READSIZE=3145728 BINDSIZE=3145728 ROWS=5000   # \ubcc0\uacbd \uc2a4\ud06c\ub9bd\ud2b8 2\ubc88 : sqlldr userid=scott\/tiger control=abc.ctl errors=999999999 READSIZE=20000000 BINDSIZE=20000000 ROWS=5000   # \ubb38\uc758\uc0ac\ud56d rows \uac12\uc744 5000\uc744 \uc8fc\uc5c8\ub294\ub370 \uc77c\uc815\ud558\uac8c commit\uc774 \ub418\uc9c0 \uc54a\ub294 \ud604\uc0c1 – \ub0b4\ubd80\uc5d0\uc11c \ud14c\uc2a4\ud2b8\uc2dc 1\ubc88 \uc2a4\ud06c\ub9bd\ud2b8\ub85c \ub3cc\ub838\uc744 \ub54c commit\uc774 4053 \ub2e8\uc704\ub85c \ucc0d\ud614\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 […]<\/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":[14],"tags":[91,92,93,94,95],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/388"}],"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=388"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/388\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=388"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}