1.準備併發測試的內容
create or replace procedure p_task is
begin
for i in 1 .. 5000 loop
    for j in (select * from scott.emp where empno=7369) loop
      null;
    end loop;
end loop;
end;

2.透過JOB的形式實現併發
--JOB的併發度依賴於引數job_queue_processes
declare
v_job_no number;
begin
for v_parallel in 1 .. 50 loop
    dbms_job.submit(job=>v_job_no,what=>'p_task;');
    commit;
end loop;
end;

3.監控
--根據需求查詢併發時的系統狀態
select * from v$session_wait
where wait_class!='Idle'

4.測試完成後刪除JOB
begin
for v_job in (select * from dba_jobs where what='p_task;') loop
    dbms_job.remove(v_job.job);
    commit;
end loop;
end;

oracle實用sql(13)--併發簡單模擬

相關文章