How to Create Schema for Swingbench A Comprehensive Guide

YouTube video

When it comes to stress testing an Oracle Database, Swingbench is an invaluable tool. In this article, we will walk you through the process of installing and configuring Swingbench, as well as demonstrate its high availability features while simulating a planned maintenance operation. Whether you’re a beginner or an experienced user, this guide will provide you with all the information you need to create a schema for Swingbench.

Table of Contents:

  1. Introduction to Swingbench and Oracle Database
  2. Step 1: Download and Install Swingbench
  3. Step 2: Build and Set Up Sample Swingbench Schema
  4. Step 3: Start the Swingbench Load Generator
  5. Step 4: Configure the Swingbench Load Generator

Introduction to Swingbench and Oracle Database

Swingbench is a free load generator designed specifically for stress testing Oracle databases. It consists of a load generator, a coordinator, and a cluster overview. With Swingbench, you can generate loads and monitor transaction response times. Additionally, it can be used to test various technologies such as real application clusters, online table rebuilds, standby databases, online backup, and recovery.

Step 1: Download and Install Swingbench

Before you can create a schema for Swingbench, you need to download and install the tool. To do this, you’ll need to connect to your developer client machine via VNC. Once connected, open a terminal window and use the curl command to download the latest version of Swingbench. After the download is complete, unzip the file to proceed to the next step.

Step 2: Build and Set Up Sample Swingbench Schema

Now that Swingbench is installed, it’s time to build the sample order entry schema in the database. SSH into your dev client machine and navigate to the “home/opc/swingbench/bin” directory. Run the order entry wizard by executing the command for the Oracle entry install wizard. The wizard will appear on your screen, and you can click “Next” to proceed. Select version 2.0 of Swingbench and continue to the next step. Choose to create the order entry schema and enter your connect string, administrator username, and password. Follow the prompts until the process is finished. Once completed, you can start the Swingbench load generator.

Step 3: Start the Swingbench Load Generator

To start the Swingbench load generator, open the Swingbench load generator screen on your developer cloud image. Select the “soe_server_side_v2” option and click “OK.” In the configuration settings, enter the necessary information such as username, password, connect string, driver type, and make sure to check the “Collect Database Statistics” option. Additionally, provide the admin username and password. Once all the information is entered, click the green start button.

Step 4: Configure the Swingbench Load Generator

Now that the Swingbench load generator is running, you can observe the transactions per minute increasing in the chart section. If desired, you can further modify the configuration settings. For example, you can increase the number of logged on sessions, shut down one of the nodes in the Exadata cloud service, or increase the initial data size. Swingbench offers flexibility in configuring the load generation to meet your specific testing needs.

In conclusion, Swingbench is an essential tool for stress testing Oracle databases. By following the steps outlined in this article, you can easily create a schema for Swingbench and start stress testing your database. Remember to monitor the transactions per minute and adjust the configuration settings as necessary. Happy load testing!