{"id":1615,"date":"2024-05-08T15:32:45","date_gmt":"2024-05-08T07:32:45","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1615"},"modified":"2024-05-08T15:32:45","modified_gmt":"2024-05-08T07:32:45","slug":"%e5%8e%8b%e6%b5%8b%e4%b8%ad%e7%9a%84%e6%b5%8b%e8%af%95%e6%95%b0%e6%8d%ae%e5%87%86%e5%a4%87%e4%b8%be%e4%be%8b","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1615","title":{"rendered":"\u538b\u6d4b\u4e2d\u7684\u6d4b\u8bd5\u6570\u636e\u51c6\u5907\u4e3e\u4f8b"},"content":{"rendered":"<pre><code class=\"language-sql\">\ndeleteptestdata.sh:\n\nsqlplus dbuser\/dbpwd &lt;&lt;EOF &gt;deleteptestdata.log\n@deleteptestdata.sql\nexit\nEOF\n\ninsertptestdata.sql:\n\nsqlplus  dbuser\/dbpwd@EP1\nalter session Enable parallel dml;\n--\u5c06\u6d4b\u8bd5\u4e2d\u8981\u7528\u5230\u7684\u8868\u7684\u65e5\u5fd7\u6a21\u5f0f\u5173\u95ed\uff0c\u63d0\u9ad8\u901f\u5ea6\nalter table table1 nologging;\nalter table table2 nologging;\nalter table table3 nologging;\n\n--\u5220\u9664\u4e0a\u4e00\u8f6e\u7684\u6d4b\u8bd5\u6570\u636e\ndelete \/*+ PARALLEL(t1,4) *\/ from table1 t1 where id like &#039;20451477%&#039;;\ncommit;\ndelete \/*+ PARALLEL(t2,4) *\/ from table2 t2 where id like &#039;20451477%&#039;;\ncommit;\ndelete \/*+ PARALLEL(t3,4) *\/ from table3 t3 where id like &#039;20451477%&#039;;\ncommit;\n\n--\u521b\u5efa\u5b58\u50a8\u8fc7\u7a0b\u5f00\u59cb\u9020\u6570\nCREATE or REPLACE PROCEDURE proc_hd_SYS_LOG_RECEPTION\nas \n        ID number(8):=30000000;\n  IMEI number(8):=30000000;\n        begin\nFor i In 1 .. 12000001 Loop\nInsert Into tablename1 (ID, REQUESTURL, REQUESTBODY, CREATEDATE, CREATEUSER, SYSVERSION, APPVERSION, IMEI, NETTYPE)\n        Select 20451477590 || Lpad(To_Char(ID), 8, &#039;0&#039;),\n        &#039;\/web\/mobile\/reception\/qmData\/syncHtData.do&#039;,\n        &#039;{&quot;info&quot;:{&quot;token&quot;:&quot;+PGxVM1Zmn6eNIUrcuKRdhbLOVlP9GRfxPbUKoSijCsZjkGO93S6Uc8vOE4DSd26hsLKwBI126fcBieVzvQmaDr\\\/KSQoFj7oT8Y5XWg5VWc=&quot;,&quot;sysVersion&quot;:&quot;TA-1054@@Android8.0.0&quot;,&quot;appVersion&quot;:&quot;\u7ad6\u5c4f2.5.4&quot;,&quot;imei&quot;:&quot;358548080910173&quot;,&quot;netType&quot;:&quot;4&quot;},&quot;param&quot;:{&quot;userId&quot;:&quot;052218171&quot;},&quot;postData&quot;:{&quot;userCode&quot;:&quot;052218171&quot;,&quot;projecCodeList&quot;:[&quot;H\\\/020-1517&quot;,&quot;H\\\/020-1518&quot;,&quot;H\\\/020-1519&quot;]}}&#039;,\n        sysdate,\n        &#039;052218171&#039;,\n        &#039;TA-1054@@Android8.0.0&#039;,\n        &#039;\u7ad6\u5c4f2.5.4&#039;,\n        3585480||Lpad(To_Char(ID), 8, &#039;0&#039;), \n        &#039;WiFi&#039;\n                                 from dual;        \n   ID:=ID+1;\n   If Mod(i,10000)=0 then\n   Commit;\n   IMEI:=IMEI+1;\n   End If;\n  End Loop;\n  end;\n  \/\nexec proc_hd_SYS_LOG_RECEPTION;\ncommit;\n---------------------------------------------\n\nCREATE or REPLACE PROCEDURE proc_hd_qm_check_header\nas \n        ID number(8):=30000000;\n        begin\nFor i In 1 .. 12000001 Loop\nInsert Into tablename2 (ID, PROJECTCODE, ZJAVAID, ZFL, ZMANSION_NO, ZUNIT_NO, ZXLID, TASK_ID, ZJCRQ, ZSGDWID, DELETED, CREATED_BY, CREATED_ON, CREATED_TS, CHANGED_BY, CHANGED_ON, CHANGED_TS, EXT1, EXT2, EXT3, ZXTHTBH, ZWGRQ, ZJGRQ, ZBLRQ, NETWORK_ID, ZFJ_NO, USERID, VERSION, CREATE_USERNAME, USER_DEPARTMENT)\n        Select 20451477590 || Lpad(To_Char(ID), 8, &#039;0&#039;),\n        &#039;H\/010-1502&#039;,\n        &#039;153784163&#039;|| TRUNC( DBMS_RANDOM.VALUE(1000, 9999) )||&#039;_&#039;|| TRUNC( DBMS_RANDOM.VALUE(100, 999) ),\n         &#039;04&#039;,\n        &#039;H\/010-1502-002&#039;,\n        &#039;H\/010-1502-002-01&#039;,\n        &#039;00001&#039;,\n         null,\n         sysdate, \n         &#039;00144FFBA8851ED6BD9C6607&#039;||TRUNC( DBMS_RANDOM.VALUE(1000, 9999) )||&#039;_&#039;|| TRUNC( DBMS_RANDOM.VALUE(100, 999)),\n          &#039;0&#039;, \n          &#039;052218171&#039;, \n          sysdate, \n          sysdate, \n          &#039;052218171&#039;,\n           sysdate,\n            sysdate,\n             &#039;0&#039;, \n             null, \n             null,\n              null,\n              null,\n               null,\n                null,\n                 null,\n                  null, \n                  null, \n                  sysdate,\n                   null,\n                    null\n                                 from dual;        \n   ID:=ID+1;\n   If Mod(i,10000)=0 then\n   Commit;\n   End If;\n  End Loop;\n  end;\n  \/\nexec proc_hd_qm_check_header;\ncommit;\n-----------------------------------------------------------------------------\nCREATE or REPLACE PROCEDURE proc_hd_qm_check_detail\nas \n        ID number(8):=30000000;\n        begin\nFor i In 1 .. 12000001 Loop\ninsert into tablename3  (ID, PROJECTCODE, JAVAID, REL_ZJAVAID, ZMANSION_NO, ZUNIT_NO, TASK_ID, REL_GUID, ZFH, ZJCDBW, ZJCJG, ZSFHG, ZSFZG, ZPL, DWID, ZJCRQ, ZYSQK, REMARK, EXT1, EXT2, EXT3, EXT4, EXT5, EXT6, CHECKPROJECTCODE, ZXCQKSM, ZZGTG, ZFCXH, ZFCRQ, FCJAVAID, ZWTFL, ZXZB, ZYZB, USERID, VERSION, ZBSLC)\n        Select 20451477590 || Lpad(To_Char(ID), 8, &#039;0&#039;),\n        &#039;H\/010-1502&#039;,\n        &#039;253784163&#039;|| TRUNC( DBMS_RANDOM.VALUE(1000, 9999) )||&#039;_&#039;|| TRUNC( DBMS_RANDOM.VALUE(100, 999) ),\n         &#039;253784163&#039;|| TRUNC( DBMS_RANDOM.VALUE(1000, 9999) )||&#039;_&#039;|| TRUNC( DBMS_RANDOM.VALUE(100, 999) ),\n         &#039;H\/020-&#039;||TRUNC( DBMS_RANDOM.VALUE(1000, 9999) )||&#039;-&#039;||TRUNC( DBMS_RANDOM.VALUE(100, 999)),\n          &#039;H\/020-1613-069-01&#039;,\n           null,\n            &#039;00144FFBA8851ED6BD9C6607&#039;||TRUNC( DBMS_RANDOM.VALUE(1000, 9999) )||&#039;_&#039;|| TRUNC( DBMS_RANDOM.VALUE(100, 999)),\n             null, \n             null, \n             null,\n              &#039;1&#039;,\n               &#039;0&#039;,\n                &#039;0.00&#039;,\n                 null,\n                  &#039;0000-00-00&#039;,\n                   null,\n                    null,\n                     &#039;1&#039;,\n                      null,\n                       null,\n                        null,\n                         null,\n                          null,\n                           null,\n                            null, \n                            null, \n                            null, \n                            null,\n                             null,\n                              null,\n                               null,\n                                null, \n                                null,\n                                 sysdate,\n                                  null\n                                 from dual;        \n   ID:=ID+1;\n   If Mod(i,10000)=0 then\n   Commit;\n   End If;\n  End Loop;\n  end;\n  \/\nexec proc_hd_qm_check_detail;\ncommit;\n-----------------------------------------------------------------------------------\n--SELECT to_char((SYSDATE - TO_DATE(&#039;1970-1-1 8&#039;, &#039;YYYY-MM-DD HH24&#039;)) * 86400 ) AS MILLIONS FROM DUAL; \/*\u751f\u6210\u79d2\u7ea7\u65f6\u95f4\u622a*\/\n--SELECT to_char((SYSDATE - TO_DATE(&#039;1970-1-1 8&#039;, &#039;YYYY-MM-DD HH24&#039;)) * 86400000 + TO_NUMBER(TO_CHAR(SYSTIMESTAMP(3), &#039;FF&#039;))) AS MILLIONS FROM DUAL; \/*\u751f\u6210\u6beb\u79d2\u7ea7\u65f6\u95f4\u622a*\/\n\nCREATE or REPLACE PROCEDURE proc_hd_qm_check_photo\nas \n        ID number(8):=30000000;\n        begin\nFor i In 1 .. 12000001 Loop\ninsert into tablename4 (ID, JAVAID, REL_DETAILID, REL_GUID, ZPL_ATTACHID, ZBUCKET, ZOBJECT_NAME, ZDISPLAY, ZIMGDESC, PROJECTCODE, IMGNAME, IMGPATH, ZZPLX, PHOTODATE, ALTERDATE, EXT1, ISCHECKED, LONGITUDE, LATITUDE, USERID, VERSION, PHOTOTYPE)\n        Select 20451477||TRUNC( DBMS_RANDOM.VALUE(100, 399))|| Lpad(To_Char(ID), 8, &#039;0&#039;),\n        to_char((SYSDATE - TO_DATE(&#039;1970-1-1 8&#039;, &#039;YYYY-MM-DD HH24&#039;)) * 86400000 + TO_NUMBER(TO_CHAR(SYSTIMESTAMP(3), &#039;FF&#039;)))||&#039;_&#039;|| TRUNC( DBMS_RANDOM.VALUE(100, 999) ),\n        to_char((SYSDATE - TO_DATE(&#039;1970-1-1 8&#039;, &#039;YYYY-MM-DD HH24&#039;)) * 86400000 + TO_NUMBER(TO_CHAR(SYSTIMESTAMP(3), &#039;FF&#039;)))||&#039;_&#039;|| TRUNC( DBMS_RANDOM.VALUE(100, 999) ),\n          null,\n           null,\n            &#039;hdpstest&#039;,\n             &#039;img\/052218171\/3\/H010-1502\/C\/&#039;||to_date(sysdate, &#039;YYYY-MM-DD&#039;)||&#039;\/&#039;||&#039;2000001478&#039;||&#039;_&#039;||to_char((SYSDATE - TO_DATE(&#039;1970-1-1 8&#039;, &#039;YYYY-MM-DD HH24&#039;)) * 86400000 + TO_NUMBER(TO_CHAR(SYSTIMESTAMP(3), &#039;FF&#039;)))||&#039;_&#039;||TRUNC( DBMS_RANDOM.VALUE(100, 999) )||&#039;.jpg&#039;,\n              &#039;1&#039;, \n              &#039;\u5de5\u7a0b3&#039;,\n               &#039;H\/010-1502&#039;,\n                &#039;2000001478_&#039;||to_char((SYSDATE - TO_DATE(&#039;1970-1-1 8&#039;, &#039;YYYY-MM-DD HH24&#039;)) * 86400000 + TO_NUMBER(TO_CHAR(SYSTIMESTAMP(3), &#039;FF&#039;)))||&#039;_&#039;||TRUNC( DBMS_RANDOM.VALUE(100, 999) )||&#039;.jpg&#039;,\n                 &#039;valueaaaaaaaaaa&#039;||to_date(sysdate, &#039;YYYY-MM-DD&#039;)||&#039;\/&#039;||to_char((SYSDATE - TO_DATE(&#039;1970-1-1 8&#039;, &#039;YYYY-MM-DD HH24&#039;)) * 86400000 + TO_NUMBER(TO_CHAR(SYSTIMESTAMP(3), &#039;FF&#039;)))||&#039;_&#039;||TRUNC( DBMS_RANDOM.VALUE(100, 999) )||&#039;.jpg&#039;,\n                  &#039;100&#039;, \n                  sysdate,\n                   null,\n                    &#039;1&#039;,\n                     &#039;1&#039;,\n                      null,\n                       null,\n                        null, \n                        sysdate,\n                        &#039;1&#039;\n                                 from dual;        \n\nexec proc_hd_qm_check_photo;\ncommit;\n\n--\u6062\u590d\u8868\u65e5\u5fd7\u8bb0\u5f55\nalter table user.dbname1  logging;\nalter table user.dbname2 logging;\nalter tableuser.dbname3 logging;\nalter table user.dbname1  logging;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>deleteptestdata.sh: sqlplus dbuser\/dbpwd &lt;&lt;EOF &gt;deleteptestdata.log @deleteptestdata.sql exit EOF insertptestdata.sql: sqlplus dbuser\/dbpwd@EP1 alter session Enable parallel dml; &#8211;\u5c06\u6d4b\u8bd5\u4e2d\u8981\u7528\u5230\u7684\u8868\u7684\u65e5\u5fd7\u6a21\u5f0f\u5173\u95ed\uff0c\u63d0\u9ad8\u901f\u5ea6 alter table table1 nologging; alter table table2 nologging; alter table table3 nologging; &#8211;\u5220\u9664\u4e0a\u4e00\u8f6e\u7684\u6d4b\u8bd5\u6570\u636e delete \/*+ PARALLEL(t1,4) *\/ from table1 t1 where id like &#039;20451477%&#039;; commit; delete \/*+ PARALLEL(t2,4) *\/ from table2 t2 where id like &#039;20451477%&#039;; commit; delete \/*+ PARALLEL(t3,4) *\/ from table3 t3 where id like &#039;20451477%&#039;; commit; &#8211;\u521b\u5efa\u5b58\u50a8\u8fc7\u7a0b\u5f00\u59cb\u9020\u6570 CREATE or REPLACE PROCEDURE proc_hd_SYS_LOG_RECEPTION as ID number(8):=30000000; IMEI number(8):=30000000; begin For i In 1 .. 12000001 Loop Insert Into tablename1 (ID, REQUESTURL, REQUESTBODY, CREATEDATE, CREATEUSER, SYSVERSION, APPVERSION, IMEI, NETTYPE) Select 20451477590 || Lpad(To_Char(ID), 8, &#039;0&#039;), &#039;\/web\/mobile\/reception\/qmData\/syncHtData.do&#039;, &#039;{&quot;info&quot;:{&quot;token&quot;:&quot;+PGxVM1Zmn6eNIUrcuKRdhbLOVlP9GRfxPbUKoSijCsZjkGO93S6Uc8vOE4DSd26hsLKwBI126fcBieVzvQmaDr\\\/KSQoFj7oT8Y5XWg5VWc=&quot;,&quot;sysVersion&quot;:&quot;TA-1054@@Android8.0.0&quot;,&quot;appVersion&quot;:&quot;\u7ad6\u5c4f2.5.4&quot;,&quot;imei&quot;:&quot;358548080910173&quot;,&quot;netType&quot;:&quot;4&quot;},&quot;param&quot;:{&quot;userId&quot;:&quot;052218171&quot;},&quot;postData&quot;:{&quot;userCode&quot;:&quot;052218171&quot;,&quot;projecCodeList&quot;:[&quot;H\\\/020-1517&quot;,&quot;H\\\/020-1518&quot;,&quot;H\\\/020-1519&quot;]}}&#039;, sysdate, &#039;052218171&#039;, &#039;TA-1054@@Android8.0.0&#039;, &#039;\u7ad6\u5c4f2.5.4&#039;, 3585480||Lpad(To_Char(ID), 8, &#039;0&#039;), &#039;WiFi&#039; from dual; ID:=ID+1; If Mod(i,10000)=0 then Commit; IMEI:=IMEI+1; End If; End Loop; end; \/ exec proc_hd_SYS_LOG_RECEPTION; commit; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; CREATE or REPLACE PROCEDURE proc_hd_qm_check_header as ID number(8):=30000000; begin For i In 1 .. 12000001 Loop Insert Into&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[88,82,101,9,80],"tags":[],"class_list":["post-1615","post","type-post","status-publish","format-standard","hentry","category-oracle","category-82","category-101","category-9","category-80"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1615","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1615"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1615\/revisions"}],"predecessor-version":[{"id":1616,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1615\/revisions\/1616"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}