Skip to content

Instantly share code, notes, and snippets.

View marcelo-ochoa's full-sized avatar

Marcelo Ochoa marcelo-ochoa

View GitHub Profile
package com.dom.benchmarking.swingbench.testcollection;
import com.dom.benchmarking.swingbench.event.JdbcTaskEvent;
import com.dom.benchmarking.swingbench.kernel.SwingBenchException;
import com.dom.benchmarking.swingbench.kernel.SwingBenchTask;
import com.dom.util.RandomUtilities;
import java.sql.Connection;
import java.sql.PreparedStatement;
package com.dom.benchmarking.swingbench.testcollection;
import com.dom.benchmarking.swingbench.event.JdbcTaskEvent;
import com.dom.benchmarking.swingbench.kernel.SwingBenchException;
import com.dom.benchmarking.swingbench.kernel.SwingBenchTask;
import com.dom.util.RandomUtilities;
import java.sql.Connection;
import java.sql.Timestamp;
package com.dom.benchmarking.swingbench.testcollection;
import com.dom.benchmarking.swingbench.kernel.DatabaseTransaction;
import com.dom.benchmarking.swingbench.kernel.SwingBenchException;
import com.dom.benchmarking.swingbench.kernel.SwingBenchTask;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
#!/bin/bash
# LICENSE UPL 1.0
#
# Copyright (c) 1982-2018 Oracle and/or its affiliates. All rights reserved.
#
# Since: November, 2016
# Author: gerald.venzl@oracle.com
# Description: Creates an Oracle Database based on following parameters:
# $ORACLE_SID: The Oracle SID and CDB name
# $ORACLE_PDB: The PDB name
#!/bin/bash
[[ $UID = "54321" ]] && rman target /<<EOF
shutdown immediate;
startup mount;
backup as compressed backupset database format '$ORACLE_BASE/scripts/setup/%U';
backup current controlfile format '$ORACLE_BASE/scripts/setup/control.bks';
backup spfile format '$ORACLE_BASE/scripts/setup/spfile.bks';
alter database open;
exit;
EOF
@marcelo-ochoa
marcelo-ochoa / launcher.xml
Created August 10, 2020 14:24
SwingBench launcher config file
<project name="Swingbench Launcher" default="swingbench" basedir=".">
<property name="base.dir" value="${basedir}/.."/>
<property name="etc.dir" value="${base.dir}/etc"/>
<property name="lib.dir" value="${base.dir}/lib"/>
<property name="log.dir" value="${base.dir}/log"/>
<path id="base.class.path">
<pathelement path="${etc.dir}"/>
@marcelo-ochoa
marcelo-ochoa / docker-compose.yml
Created August 10, 2020 14:22
Docker swarm stack Oracle Cloud version
version: "3.6"
services:
oesetup:
image: swingbench:2.6.0
command: /opt/swingbench/bin/oewizard -cf /opt/Wallet_test2.zip -dba "admin" -dbap ${ADMIN_PWD} -cs test2_high -create -scale 0.8 -v -cl -ts DATA -u soe -p ${SOE_PWD} -async_off
volumes:
- /gluster-storage/Wallet_test1.zip:/opt/Wallet_test1.zip
- /gluster-storage/Wallet_test2.zip:/opt/Wallet_test2.zip
deploy:
@marcelo-ochoa
marcelo-ochoa / docker-compose.yml
Created August 10, 2020 13:40
Swarm stack definition for local testing
version: "3.6"
volumes:
test-19c: {}
services:
db:
image: oracle/database:19.3.0-ee
volumes:
- test-19c:/opt/oracle/oradata
@marcelo-ochoa
marcelo-ochoa / Dockerfile
Created August 10, 2020 13:34
Dockerfile for building swingbench docker image
# usage note:
# docker build -t swingbench:2.6.0 .
FROM adoptopenjdk/openjdk8
WORKDIR /opt
ADD https://github.com/domgiles/swingbench-public/releases/download/production/swingbenchlatest.zip /tmp
RUN jar xvf /tmp/swingbenchlatest.zip && chmod +x /opt/swingbench/bin/*
version: '3.7'
x-default-opts:
&default-opts
logging:
options:
max-size: "1m"
deploy:
mode: replicated
replicas: 1