testload.sh

#!/bin/bash
 
if [[ "$1" = '-s' ]]; then
sqlplus -s scott/oracle@ORCL<<EOF
declare
  foo clob;
begin
  dbms_application_info.set_action('LOBLOAD');
  foo:=rpad(dbms_random.value(),30000,dbms_random.value());
  for i in 1..1000 loop
    insert into T (id, payload1) 
      (select secfile_seq.nextval, foo from dual connect by level
<=1000);
    commit;
  end loop;
end;
/
EOF
exit
fi
 
c=0
while [[ $c -lt 20 ]]; do
  let c=$c+1
  $0 -s >>lobload.log  &
done