关闭oracle表并发,每秒900，一天400万数据，如何控制并发操作表数据？

Declare

time_index Number;

start_time Timestamp(3);

tmp_time Timestamp(3);

tmp_value1 Float;

tmp_value2 Float;

tmp_value3 Float;

tmp_value4 Float;

tmp_value5 Float;

tmp_value6 Float;

tmp_value7 Float;

tmp_value8 Float;

tmp_value9 Float;

tmp_value10 Float;

tmp_value11 Float;

tmp_value12 Float;

tmp_value13 Float;

tmp_value14 Float;

tmp_value15 Float;

tmp_value16 Float;

Begin

--initiaze the variable

time_index:=0;

--  start_time:=to_timpstamp('2016-08-01 00:00:00.000','yyyy-mm-dd hh24:mi:ss');

SELECT to_timestamp('2016-08-01 00:00:00:000', 'yyyy-mm-dd hh24:mi:ss:ff') Into start_time  FROM DUAL;

dbms_output.put_line(start_time);

While time_index

Loop

-- add 20 millionseconds

SELECT start_time+numtodsinterval((0.02*time_index),'SECOND') Into tmp_time  FROM DUAL;

-- dbms_output.put_line(tmp_time);

-- create random number

select dbms_random.value Into tmp_value1 from dual ;

select dbms_random.value Into tmp_value2 from dual ;

select dbms_random.value Into tmp_value3 from dual ;

select dbms_random.value Into tmp_value4 from dual ;

select dbms_random.value Into tmp_value5 from dual ;

select dbms_random.value Into tmp_value6 from dual ;

select dbms_random.value Into tmp_value7 from dual ;

select dbms_random.value Into tmp_value8 from dual ;

select dbms_random.value Into tmp_value9 from dual ;

select dbms_random.value Into tmp_value10 from dual ;

select dbms_random.value Into tmp_value11 from dual ;

select dbms_random.value Into tmp_value12 from dual ;

select dbms_random.value Into tmp_value13 from dual ;

select dbms_random.value Into tmp_value14 from dual ;

select dbms_random.value Into tmp_value15 from dual ;

select dbms_random.value Into tmp_value16 from dual ;

--dbms_output.put_line(tmp_value);

-- Insert Into ac_data (sensor_id,data,record_time) Values(sensor_index,tmp_value,tmp_time);

Insert Into real_data Values(tmp_time,tmp_value1,tmp_value2,tmp_value3,tmp_value4,tmp_value5,tmp_value6,tmp_value7,tmp_value8,tmp_value9,tmp_value10,tmp_value11,tmp_value12,tmp_value13,tmp_value14,tmp_value15,tmp_value16);

if mod(time_index,50)=0 then

commit;

dbms_lock.sleep(1);

End If;

time_index:=time_index+1;

End Loop;

Exception

WHEN OTHERS THEN

dbms_output.put_line('exception done!')；

End;