Home > Workload Solutions > Oracle > Guides > Reference Architecture Guide—Dell EMC Ready Solutions for Oracle: Design for Unity All Flash Storage > SLOB dataset customization
We replaced the default dataset that was loaded by SLOB with a custom and unique dataset using the following PL/SQL script:
/* Truncate/remove original rows in tables for all users/schemas (128 schemas in our case) */
for i in {1..128}
do
sqlplus / as sysdba << EOF
truncate table user${i}.cf1;
exit;
EOF
done
/* Start code for inserting random/unique data */
for i in {1..128}
do
sqlplus / as sysdba <<EOF
declare
type cf_table is table of user1.cf1%rowtype
index by binary_integer;
cfa cf_table;
begin
for i in 1..2450000 loop -- Loop through each row to generate random and unique data for each column
cfa(i).custid:=i;
cfa(i).c2:=dbms_random.string('p',128);
cfa(i).c3:=dbms_random.string('p',128);
cfa(i).c4:=dbms_random.string('p',128);
cfa(i).c5:=dbms_random.string('p',128);
cfa(i).c6:=dbms_random.string('p',128);
cfa(i).c7:=dbms_random.string('p',128);
cfa(i).c8:=dbms_random.string('p',128);
cfa(i).c9:=dbms_random.string('p',128);
cfa(i).c10:=dbms_random.string('p',128);
cfa(i).c11:=dbms_random.string('p',128);
cfa(i).c12:=dbms_random.string('p',128);
cfa(i).c13:=dbms_random.string('p',128);
cfa(i).c14:=dbms_random.string('p',128);
cfa(i).c15:=dbms_random.string('p',128);
cfa(i).c16:=dbms_random.string('p',128);
cfa(i).c17:=dbms_random.string('p',128);
cfa(i).c18:=dbms_random.string('p',128);
cfa(i).c19:=dbms_random.string('p',128);
cfa(i).c20:=dbms_random.string('p',128);
end loop;
for all i in 1..cfa.count
insert into user${i}.cf1 values cfa(i); -- Insert the above newly generated random+unique data into each column of each row
end;
/
exit;
EOF
done