domgiles

begin
    dbms_cloud.create_credential(
            credential_name => 'obj_store_cred2',
            username => 'domgiles',
            password => 'areallysecretpassword'
        );
end;

BEGIN
    DBMS_CLOUD.EXPORT_DATA(

domgiles

 BODY {
 background-color: White;
 font-family: "Lucida Grande","Lucida Sans Unicode",geneva,arial,verdana,sans-serif;
 color: #777;
 font-size:8pt;
}

.data {
        border-top : 1px solid #777;
        border-bottom : 1px solid #777;

domgiles

./charbench -cf ~/wallet_DOMADW.zip \
            -cs domadw_high \
            -u tpcds \
            -p <your user password> \
            -c ../configs/TPCDS_Like_Workload.xml \
            -uc 4 \
            -intermin 0 \
            -intermax 0 \
            -v trem,users,tpm,tps,tottx,resp \
            -rt 0:10

domgiles

python ../utils/enable_tpcds_queries.py -c ../configs/tpcds_statements.xml -s query69 -d;
python ../utils/enable_tpcds_queries.py -c ../configs/tpcds_statements.xml -s query10 -d;
python ../utils/enable_tpcds_queries.py -c ../configs/tpcds_statements.xml -s query45 -d;

domgiles

./tpcdswizard -cf ~/wallet_DOMADW.zip \
              -cs domadw_high \
              -ts DATA \
              -its DATA \
              -dbap <Your admin Password> \
              -dba admin \
              -u tpcds \
              -p <Your user password> \
              -async_off \
              -scale 10 \

domgiles

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<CPUMonitor Title="Compute Nodes" xmlns="http://www.dominicgiles.com/cpumonitor">
    <MonitoredNode>
        <HostName>129.146.65.101</HostName>
        <Username>opc</Username>
        <Password>Your ssh password</Password>
        <Port>22</Port>
        <PrivateKey>/Users/dgiles/.ssh/id_rsa</PrivateKey>
        <Comment>OCI Server</Comment>
    </MonitoredNode>

domgiles

./oewizard -cf ~/wallet_SBATP.zip \
           -cs sbatp_medium \
           -ts DATA \
           -dbap <your admin password> \
           -dba admin \
           -u soe \
           -p <your soe password> \
           -async_off \
           -scale 5 \
           -hashpart \

domgiles

./charbench -c ../configs/SOE_Server_Side_V2.xml \
            -cf ~/wallet_SBATP.zip \
            -cs sbatp_low \
            -u soe \
            -p <your soe password> \
            -v users,tpm,tps,vresp \
            -intermin 0 \
            -intermax 0 \
            -min 0 \
            -max 0 \

domgiles

sed -i -e 's/<LogonGroupCount>1<\/LogonGroupCount>/<LogonGroupCount>5<\/LogonGroupCount>/' \
       -e 's/<LogonDelay>0<\/LogonDelay>/<LogonDelay>300<\/LogonDelay>/' \
       -e 's/<WaitTillAllLogon>true<\/WaitTillAllLogon>/<WaitTillAllLogon>false<\/WaitTillAllLogon>/' \
       ../configs/SOE_Server_Side_V2.xml

domgiles