RWP*Load Simulator
This is the RWP*Load Simulator - a tool that can be used for several purposes:
- Simulate a workload using an Oracle database
- Write shell scripts that are closely integrated with Oracle SQL
Please see the docs directory for Users' Guide; the reference manual is available after installation using rwlman and from https://oracle.github.io/rwloadsim/refman/
News
Release 3.0.1 includes three major new features:
- SQL declaration no longer needs explicit bind and/or define, as bind variables and select list elements can be implicitly matched to declared variables.
- The separate declaration and subsequent execution of SQL is no longer needed.
- Formatting of output using printf.
In addition, there are several minor update, a number of bug fixes and updates to the standard oltp workload as shown in CHANGELOG.md.
Branches
The branches that should be used by ordinary users are named after the release, e.g. 3.0.0. The master branch is always the development branch and may as such contain intermediate code. You should normally not clone or checkout the master branch unless you are developing the rwloadsim code or always want the latest. If you use the master branch, you must do compilation yourself; no binaries are released.
At present, branch 3.0.0 is the release branch which is at Beta status. After sufficient testing it will be replaced by 3.0.1 Production.
Please see CHANGELOG.md for details.
Using a binary distribution
Using a binary distribution is simple as all it requires is an Oracle Client environment and access to one (or more) databases. Please see docs/INSTALL.md for details.
Getting started
The suggested documentation for getting started is the first two chapters of the users manual available at docs/index.md. To get quickly started with some of the rwloadsim basics, a good starting point is at docs/WORKING.md. The demo directory contains all files mentioned there.
Building rwloadsim from sources
Please see BUILDING.md
Documentation
The users guide is found in docs and is distributed into a number of .md files. You should start with docs/index.md which has a very brief introduction and links to all files of the users guide.
The reference guide is created as manual pages that are found in man/man1rwl.
The shell script rwlman, that will be copied to the bin directory when you run make
is the documented way to read these manual pages.
Simply start by typing rwlman.
Included workload
Both the binary and source distributions include a complete
oltp workload.
Please see docs/OLTP.md for details.
Next steps in evolving rwloadsim
What would you like to see in upcoming releases of rwloadsim? Some ideas that I have myself are:
- Add a "date" data type that can be used similarly to dates in SQL and PL/SQL
- Add "raw" and "blob" data types together with support for binary files
- Add an fprintf statement for advanced output formatting
- Add input of hexadecimal (and octal) plus binary operators such as <<, >>, &, |
Please contact me with suggestions and ideas. You are also welcome to contribute.