Skip to content

Instantly share code, notes, and snippets.

View domgiles's full-sized avatar

Dominic Giles domgiles

View GitHub Profile
./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 \
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;
./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
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
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(