Skip to content

Instantly share code, notes, and snippets.

View domgiles's full-sized avatar

Dominic Giles domgiles

View GitHub Profile
@domgiles
domgiles / oracle_hybrid_partitions_ADB.sql
Last active August 5, 2022 09:18
Create and exchange partitions in a hybrid paritioned table on ADB
begin
dbms_cloud.create_credential(
credential_name => 'obj_store_cred2',
username => 'domgiles',
password => 'areallysecretpassword'
);
end;
BEGIN
DBMS_CLOUD.EXPORT_DATA(
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;
./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
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;
./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 \
<?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>
./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 \
./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 \
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
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.