Increasing Load On The Database Server
Creating a table:
create table t (id number, sometext varchar2(50),my_date date) tablespace test;
Now we will create a simple procedure to load bulk data:
create or replace procedure manyinserts as
v_m number;
begin
for i in 1..10000000 loop
select round(dbms_random.value() * 44444444444) + 1 into v_m from dual ;
insert /*+ new2 */ into t values (v_m, 'DOES THIS'||dbms_random.value(),sysdate);
commit;
end loop;
end;
/
Now this insert will be executed in 10 parallel sessions using dbms_job, this will fictitiously increase load on database:
create or replace procedure manysessions as
v_jobno number:=0;
begin
FOR i in 1..10 LOOP
dbms_job.submit(v_jobno,'manyinserts;', sysdate);
END LOOP;
commit;
end;
/
Now we will execute manysessions which will increase 10 parallel sessions:
exec manysessions;
Check the table size:
select bytes/1024/1024/1024 from dba_segments where segment_name='T';
No comments:
Post a Comment