rwloadsim

The RWP*Load Simulator

The RWP*Load Simulator is a tool developed by the Real World Performance group at Oracle Corporation.

SQL*Plus is a great tool for executing ad hoc SQL and writing reports, PL/SQL is ideal for writing database centric application code, and the Bourne-Again SHell, bash, is very useful for scripting and programming. If you ever had the need for programming SQL*Plus, executing PL/SQL on the client side or execute SQL from bash, you have come to the right place. This gap is exactly what the RWP*Load Simulator is filling in addition to its ability to actually simulate load.

Release 3.1 of the tool has primary focus on the facilities for scripting, and it includes a much more versatile and easier to use model for executing SQL, advanced printf style output and much more. Please make sure to read NEWS31.md that describes important changed behavior and all new features.

Release 3.2 has further focus on scripting facilicites, and it adds bitwise operations and hexadecimal input. The full list of changes is available in NEWS32.md.

If you think of a bit of bash and SQL, a dose of PL/SQL, a nip of C or Java, a fragment of Oracle Call Interface, a dash of awk, a grain of sed plus a few drops of secret sauce and put it all into one tool, you will have another idea about what rwloadsim is. In its core, it is a programming language that takes a bit of each of these known tools and programming languages and integrates them into one.

Getting the RWP*Load Simulator

The tool is available at https://github.com/oracle/rwloadsim where you will find both sources and binary distributions.

RWP*Load Simulator users guide

Introduction

• WHATISIT.md What is the RWP*Load Simulator
• INTRODUCTION.md A brief introduction the RWP*Load Simulator
• INSTALL.md Install the software from binary distribution and create the repository
• NEWS32.md News in version 3.2
• NEWS31.md News in versions 3.0 and 3.1
• WORKING.md Working with rwloadsim using a few examples
• SCRIPTING.md Using rwloadsim for scripting

Basic concepts

• SCALAR.md Declaring scalars such as integers and doubles
• PROCFUNC.md Declaring procedures and functions
• COMPOUND.md Use of compound statements such as if/then/else and loops
• SQL.md Declaring and using static SQL
• EXPRESSION.md Expressions and assignments
• PRINTF.md Formatted output using sprintf, printf, fprintf
• FILE.md Use of files and pipe-lines
• DATABASE.md Declaration and use of databases
• ATCLAUSE.md Using the at clause to choose a database
• RANSTRING.md Providing random strings
• RANPROC.md Randomly executing some procedure
• SIMULATOR.md Simulating workload using threads

Using the rwloadsim program

• RWLOADSIM.md Calling the rwloadsim tool
• ARGUMENTS.md Providing arguments on the command line to your rwloadsim program
• COMPILE.md Compilation and execution
• STATISTICS.md Saving and using run time statistics
• DIRECTIVES.md Using directives to modify behavior

Samples, public utilities and files, oltp workload

• COMPLEXAMPLE.md A complete example
• YOUROWNWL.md Creating your own workload
• ORACLENET.md Utilities to measure database “ping” rates and network throughput
• MISCUTIL.md Miscellaneous utilities and include files
• SAMPLEOLTP.md Sample use cases with the oltp workload
• OLTP.md Setup and use of the oltp workload
• OLTPQUICKSTART.md Quickstart of the oltp workload for experienced users

Advanced features

• CLOB.md Using CLOB data
• DYNAMICSQL.md Declaring and using dynamic SQL
• REGEX.md Dealing with regular expression search and substitute
• CONSTORM.md Avoiding connection storms
• ERROR.md Error handling during parse and execution
• INTERPRETER.md Using rwloadsim as an interpreter
• GENERATE.md Generating stand alone executables
• INTERRUPT.md Interrupting rwloadsim
• MODULAR.md Methods for modular programming
• MULTI.md Running multiple processes as one simulation
• QUEUEING.md Handling queuing in control loops

Microsoft Windows

• WINDOWS.md Installation and use on Microsoft Windows

RWL error listing

• ERRORLIST.md Complete list of RWL- errors

RWP*Load Simulator reference manual

The reference manual is distributed as a large number of pages that are very similar to ordinary UNIX man-pages; they are available after installation and online at refman/README.md. There is a single shell script, rwlman, that is used rather than the ordinary man command, to display these. As a starting point, simply type

rwlman

This site is open source. Improve this page.