{"id":212,"date":"2019-09-20T11:28:23","date_gmt":"2019-09-20T03:28:23","guid":{"rendered":"https:\/\/blog.dbtopas.com\/?p=212"},"modified":"2019-09-20T14:27:51","modified_gmt":"2019-09-20T06:27:51","slug":"oracle-sql-loader-145%e8%90%ac%e7%ad%86%e8%b3%87%e6%96%99","status":"publish","type":"post","link":"https:\/\/blog.dbtopas.com\/?p=212","title":{"rendered":"Oracle SQL*Loader loads 145\u842c\u7b46\u8cc7\u6599"},"content":{"rendered":"<p>\u672c\u4f86\u9019\u6b21\u8655\u7406\u516c\u53f8\u7684\u554f\u984c\u662f\u8981\u7528Perl\u89e3\u6c7a,\u4f46\u56e0\u70ba\u9700\u8981\u4e00\u6b21\u6027\u7684\u66f4\u65b0145\u842c\u7b46\u5de6\u53f3\u7684\u8cc7\u6599,\u76ee\u6a19\u8cc7\u6599\u8868\u7684\u8cc7\u6599\u91cf\u90a3\u662f\u597d\u5e7e\u500b\u5104\u7b46,\u800c\u4e14\u96a8\u6642\u90fd\u5728\u7570\u52d5\u4e2d,\u53c8\u52a0\u4e0a\u662f\u7dda\u4e0a\u7cfb\u7d71.\u5982\u679c\u771f\u7684\u4f7f\u7528Perl\u8b80CSV\u6a94\u5f8c,\u518d\u4e00\u7b46\u4e00\u7b46\u7684\u66f4\u65b0\u8cc7\u6599,\u771f\u4e0d\u77e5\u9053\u8981\u8655\u7406\u591a\u4e45.\u6240\u4ee5\u5728\u5beb\u4e86\u4e00\u4e9b\u7684\u6e2c\u8a66\u7a0b\u5f0f\u767c\u73fe\u6548\u80fd\u592a\u5dee\u5f8c,\u5c31\u6c7a\u5b9a\u6539\u7528SQL\u6307\u4ee4\u4f86\u6279\u91cf\u8655\u7406.<\/p>\n<p>\u7b2c\u4e00\u4ef6\u8981\u505a\u7684\u4e8b\u5c31\u662f\u628a\u5916\u90e8\u6a94\u6848\u532f\u5165\u5230\u8cc7\u6599\u5eab,\u9700\u8981\u4f7f\u7528sqlldr\u6307\u4ee4\u4f86\u5b8c\u6210<\/p>\n<pre><code class=\"language-sql\">sqlldr CONTROL= sqlldr_load_data.ctl LOG= sqlldr_load_data.ctl.log<\/code><\/pre>\n<p><!--more--><\/p>\n<p>\u63a5\u8457\u64b0\u5bebControl\u6a94\u532f\u5165CSV\u6a94<\/p>\n<pre><code class=\"language-sql\">LOAD DATA\r\nINFILE '\/tmp\/data.csv'\r\nINSERT INTO TABLE TMP_DATA\r\nFIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"'\r\nTRAILING NULLCOLS\r\n(\r\nCASE_REPORT_TYPE,\r\nHOSP_ID,\r\nHOSP_DATA_TYPE,\r\nFEE_YM,\r\nTREAT_DT,\r\nTREAT_TYPE,\r\nFUNC_SEQ_NO,\r\nRECARD_MARK,\r\nID,\r\nBIRTHDAY,\r\nORDER_CODE,\r\nASSAY_UPLOAD_DATE,\r\nREAL_INSPECT_DATE\r\n)<\/code><\/pre>\n<p>\u56e0\u70ba\u516c\u53f8\u7684\u4e3b\u6a5f\u898f\u683c\u9084\u53ef\u4ee5,\u57f7\u884c\u532f\u5165\u7684\u52d5\u4f5c\u5927\u7d04\u53ea\u82b1\u4e86\u5e7e\u79d2\u9418\u5c31\u5b8c\u6210\u4e86.<\/p>\n<pre><code class=\"language-html\">x  ------------------------------                                              \r\nx  N    N  M    M   OOOO   N    N   For online help type: h                   \r\nx  NN   N  MM  MM  O    O  NN   N   For command line option help:             \r\nx  N N  N  M MM M  O    O  N N  N      quick-hint  nmon -?                    \r\nx  N  N N  M    M  O    O  N  N N    full-details  nmon -h                    \r\nx  N   NN  M    M  O    O  N   NN   To start nmon the same way every time?    \r\nx  N    N  M    M   OOOO   N    N    set NMON ksh variable, for example:      \r\nx  ------------------------------    export NMON=cmt                         \r\nx    TOPAS_NMON                                                              \r\nx                              40 - CPUs currently                             \r\nx                              40 - CPUs configured                          \r\nx                            4190 - MHz CPU clock rate                     \r\nx                  PowerPC_POWER8 - Processor                                 \r\nx                          64 bit - Hardware                                \r\nx                          64 bit - Kernel                                   \r\nx                            1,HA - Logical Partition                          \r\nx                   7.1.4.32 TL04 - AIX Kernel Version                         \r\nx                                 - Hostname                                    \r\nx                                 - Node\/WPAR Name                           \r\nx                         84CF697 - Serial Number                             \r\nx                    IBM,9119-MME - Machine Type\r\nx Memory qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqx\r\nx          Physical  PageSpace |        pages\/sec  In     Out | FileSystemCachex\r\nx% Used       99.9%      5.8%  | to Paging Space   0.0    0.0 | (numperm) 30.2%x\r\nx% Free        0.1%     94.2%  | to File System  490.0 65974.8| Process   56.1%x\r\nxGB Used     127.9GB     1.8GB | Page Scans    65125.8        | System    13.6%x\r\nxGB Free       0.1GB    30.2GB | Page Cycles       0.0        | Free       0.1%x\r\nxTotal(GB)   128.0GB    32.0GB | Page Steals   65179.8        |           -----x\r\nx                              | Page Faults    3901.1        | Total    100.0%x\r\nx------------------------------------------------------------ | numclient 30.2%x\r\nxMin\/Maxperm     2489MB(  3%)  74685MB( 90%) &lt;--% of RAM      | maxclient 90.0%x\r\nxMin\/Maxfree     960   1088       Total Virtual  160.0GB      | User      77.0%x\r\nxMin\/Maxpgahead    2      8    Accessed Virtual   81.6GB 51.0%| Pinned    44.3%x\r\nx                                                             | lruable pages  x\r\nxqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqx\r\n<\/code><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-220 alignnone\" src=\"https:\/\/blog.dbtopas.com\/wp-content\/uploads\/2019\/09\/SQL-Loader-Architecture.png\" alt=\"\" width=\"759\" height=\"613\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u4f86\u9019\u6b21\u8655\u7406\u516c\u53f8\u7684\u554f\u984c\u662f\u8981\u7528Perl\u89e3\u6c7a,\u4f46\u56e0\u70ba\u9700\u8981\u4e00\u6b21\u6027\u7684\u66f4\u65b0145\u842c\u7b46\u5de6\u53f3\u7684\u8cc7\u6599,\u76ee\u6a19\u8cc7\u6599\u8868\u7684\u8cc7\u6599\u91cf\u90a3\u662f\u597d [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-212","post","type-post","status-publish","format-standard","hentry","category-02pg"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/blog.dbtopas.com\/index.php?rest_route=\/wp\/v2\/posts\/212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.dbtopas.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.dbtopas.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.dbtopas.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.dbtopas.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=212"}],"version-history":[{"count":14,"href":"https:\/\/blog.dbtopas.com\/index.php?rest_route=\/wp\/v2\/posts\/212\/revisions"}],"predecessor-version":[{"id":239,"href":"https:\/\/blog.dbtopas.com\/index.php?rest_route=\/wp\/v2\/posts\/212\/revisions\/239"}],"wp:attachment":[{"href":"https:\/\/blog.dbtopas.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.dbtopas.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.dbtopas.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}