网站的建立步骤,定制开发电商网站建设哪家好,通辽网站公司,网站设计大概多少钱现在有数十万张表要从A库通过insert into tablename select * from tablenamedblink的方式导入到B库中。B机上80个cpu#xff0c;160G内存。希望能够大量并发执行。怎么写脚本呢#xff1f;谁有这方面的经验#xff0c;麻烦指点一下。谢谢。下面是我的脚本#xff1a;#!/us…现在有数十万张表要从A库通过insert into tablename select * from tablenamedblink的方式导入到B库中。B机上80个cpu160G内存。希望能够大量并发执行。怎么写脚本呢谁有这方面的经验麻烦指点一下。谢谢。下面是我的脚本#!/usr/bin/sh#最大进程数v_max_session310#进程计数器,用来计算当前正在执行的进程数量v_session_counter0v_pipe_namev_log_namev_table_ownerv_table_namev_part_namev_param_filelist_table.txtf_insert_data(){sqlplus -s ${v_dest_tns} EOFset timing on time on autocommit onprompt truncate table ...declarev_sql varchar2(300);beginbeginv_sql :truncate table ${v_table_owner}.${v_table_name} reuse storage;execute immediate v_sql;insert into trunlog values (${v_table_owner},${v_table_name},,sysdate,truncate successfull,v_sql);commit;exception when others theninsert into trunlog values (${v_table_owner},${v_table_name},,sysdate,fail successfull,v_sql);commit;end;beginv_sql :insert /* append */ into ${v_table_owner}.${v_table_name} nologging select * from ${v_table_owner}.${v_table_name}JLDM;execute immediate v_sql;insert into trunlog values (${v_table_owner},${v_table_name},,sysdate,insert successfull,v_sql);exception when others theninsert into trunlog values (${v_table_owner},${v_table_name},,sysdate,insert fail,v_sql);commit;end;insert into trunlog values (${v_table_owner},${v_table_name},,sysdate,truncate successfull,v_sql);exception when others theninsert into trunlog values (${v_table_owner},${v_table_name},,sysdate,fail,);commit;end;/exit;EOF}while read v_table_owner v_table_name v_part_namedowhile [ $v_session_counter -ge $v_max_session ]doecho . \csleep 1v_session_counter0ps -ef | grep -v grep | grep sqlplus | wc -l | read v_session_counterdonef_insert_datav_session_counter0ps -ef | grep -v grep | grep imp | wc -l | read v_session_counterecho session counter: ${v_session_counter}donelist_table.txt里面的内容如下JLCRM DW_NEWBUSI_SVC_MM_439 DW_NEWBUSI_SVC_MM200508PARAM DIM_STAT_SP_TMP NULLJLCRM DW_IMEI_USER_MM_431 DW_IMEI_USER_MM200509DM DM_SMS_BASE_437_20090816 NULLJLCRM DW_IMEI_USER_MM_432 DW_IMEI_USER_MM200509DM DM_OWE_BASE_439_20090816 NULLJLCRM DW_IMEI_USER_MM_433 DW_IMEI_USER_MM200509DM DM_SMS_BASE_438_20090816 NULLJLCRM DW_IMEI_USER_MM_434 DW_IMEI_USER_MM200509第一列是用户名第二列是表名第三列是分区名。我要实现的功能是并发度300个。一起做insert into select 操作。但我运行时发现不能并发。每次只有一个insert操作。麻烦有经验的朋友帮忙看看改一下。谢谢。
