性能测试自己写存储过程

制造大量数据时可以自己写存储过程，创建用户如下：

create or replace procedure testzhou(n in  integer) is
i  integer;
usrId varchar2(32);
memNo varchar2(32);
srex varchar2(32);
begin
  i:=0;
  loop
  i:=i+1;
  select sys_guid() into usrId from dual;
    select sys_guid() into memNo from dual;
   select lpad(i,7,0) into srex from dual;
insert into mem_users (USER_ID, PASSWORD, STATUS, TYPE_CODE, CUST_TYPE, REGISTER_SOURCE, CREATE_USER, MODIFIED_USER, CREATE_TM, MODIFIED_TM, IS_DIFF_ORDER_USER, IS_TRANSGENDER, REGION_CODE, SYS_SYNC_CODE, IS_BILL_ACCOUNT, IS_JF_ACCOUNT, MONTH_TICKET, TICKET_DEADLINE, MEM_NO, REG_TM, NICK_NAME)
values (usrId, 'e10adc3949ba59abbe56e057f20f883e', 'Y', '0', '0', '1', '', '', to_date('31-07-2013 20:30:50', 'dd-mm-yyyy hh24:mi:ss'), to_date('04-08-2013 03:04:58', 'dd-mm-yyyy hh24:mi:ss'), '0', '0', 'CN', '', '0', '1', '', null, memNo, to_date('31-07-2013 20:30:50', 'dd-mm-yyyy hh24:mi:ss'), 'lishishi'||i);
insert into mem_user_tickets (ID, USERNAME, TYPE, STATUS, USER_ID, REMARK, LAST_LOGIN_TM, CREATE_TM, MODIFIED_TM)
values (sys_guid(), 'lishishi'||srex, 'C', 'Y', usrId, '性能测试数据,请勿动', null, null, null);
insert into mem_user_info (ID, PROVINCEID, PROVINCENAME, CITYID, CITYNAME, COUNTYNAME, COUNTYID, COUNTRYID, COUNTRYNAME, MOBILE, PHONE, ADDRESS, COMPANY, USER_ID, NAME, EMAIL_ADDR, IS_DELETE, MOBILE_IS_VALIDATE, POSTCODE, MAIL_IS_VALIDATE, CREATE_TM, MODIFIED_TM, SEX, DEPT_NAME, POSITION, AGE, VALIDATE_MOBILE_TM)
values (sys_guid(), '', '', '', '', '', '', '', '', '', '', '', '', usrId, '', '', '0', 'N', '', 'N', to_date('01-08-2013 08:46:46', 'dd-mm-yyyy hh24:mi:ss'), to_date('01-08-2013 08:46:46', 'dd-mm-yyyy hh24:mi:ss'), '', '', '', null, to_date('01-08-2013 20:57:20', 'dd-mm-yyyy hh24:mi:ss'));

if  mod(i,10000)=0
then
commit;
end if;
exit when i=n;
commit;
end loop;
end testzhou;