Release 3.1.3 Production

Release 3.1.3 primarily contains updates and additions to the standard OLTP workload and additionally has various bug fixes to the rwloadsim executable. Note that there are a few updates needed in the repository to support new features in the OLTP workload.

As of 3.1.3, oracle client 23.4 is supported and oracle client 18 is de-supported.

md5sums are:

fcaf0611f7600d2c22e54f4e9e8f4e4f  generated-11-linux-x86_64-bin-3.1.3.tgz
8906ea18078f0b2638e381498aa6ea59  generated-linux-x86_64-bin-3.1.3.tgz
b7bafb62d2c92aca0103937ac14f0800  rwloadsim-linux-x86_64-bin-3.1.3.tgz

c7d2af5f3fef59a0fa6fb64f00b09a39  generated-Windows-x86_64-bin-3.1.3.zip
50f307b546b5fb0542619efdbac56817  rwloadsim-Windows-x86_64-bin-3.1.3.zip

Release 3.1.2 Production

Release 3.1.2 has been released with the following primary changes:

• Several enhancements and bug fixes to both rwloadsim itself and to the oltp workload.
• The generated executables include more of the standard utilities
• The awrreport utility can generate a global report
• On Linux, there is full end-to-end tracing available exposed in new ATIME and DTIME columns in the repository
• The rwloadsim tool itself and the generated utilities (e.g. ociping, connping) is available on Microsoft Windows. The oltp workload is not and is unlikely to be available on Windows.

You can upgrade to the new version in place, but please note, that the repository must be upgraded using the rwl312.sql file before you attempt using the new release.

Note that there are three types of downloads:

• Files named rwloadsim*-bin-N.N.N.tgz (or .zip) are for most normal general purpose use.
• Files named generated*-N.N.N-tgz (or .zip) only contain the generated utilities such as ociping.
• Files named rwloadsim*-binonly-N.N.N.tgz (or .zip) can only be used to install on top of a source distribution. The result will be as if you used the source distribution to compile youself.

To verify your downloads, you can use these md5sum's:

67adec6a8c5b3403e5a227bbb6fcfd07  generated-11-linux-x86_64-bin-3.1.2.tgz
54328a978be36b05eb97296b1234ab7f  generated-linux-x86_64-bin-3.1.2.tgz
5e2ce9420207d8c9030f2b559c8b62b0  rwloadsim-linux-x86_64-bin-3.1.2.tgz
07f604bd64c4ea7aca46c2135c8297da  rwloadsim-linux-x86_64-binonly-3.1.2.tgz

8f3e119e291d7498e7959a5ed472130b  rwloadsim-Windows-x86_64-bin-3.1.2.zip
4f156a558b764caea6e26727d915be64  generated-Windows-x86_64-bin-3.1.2.zip

2f403534b6c25e2a3132e8e9b651a97a  generated-linux-aarch64-bin-3.1.2.tgz
ce7354e7aecadf8770987042b3e3eafc  rwloadsim-linux-aarch64-bin-3.1.2.tgz
8e9b6fe9758f3b742755c7648712d130  rwloadsim-linux-aarch64-binonly-3.1.2.tgz

Release 3.1.0 Production

Release 3.1.0 of the RWP*Load Simulator has primary focus on the use of rwloadsim as a scripting tool. A tool that should be as important for you as sqlplus is. A tool that you always install right away as soon as you install an Oracle Client.

Some of the new features available in 3.1.0 are:

• Simplified use of SQL in your rwl program with e.g. ampersand replacement modelled after the use of & in sqlplus.
• Ability to log all SQL being executed
• Several additions including new functions in expressions
• For loops enhanced to be over a list of values

Additionally, there are bug fixes and if you use rwloadsim for actual simulation, the standard oltp workload has been improved.

Note that to open a file or a pipeline, you need to use the syntax with the appropriate assignment operator. Rwloadsim will no longer inspect the file name to find the open method.

The following files are available for download:

• Full binary distribution for X86_64 and ARM: rwloadsim-linux-x86_64-bin-3.1.0.3.tgz, rwloadsim-linux-aarch64-bin-3.1.0.3.tgz
• Binary only distributions to put on top of clone or pull: rwloadsim-linux-x86_64-binonly-3.1.0.3.tgz, rwloadsim-linux-aarch64-binonly-3.1.0.3.tgz
• Generated binaries that can be used completely stand alone: generated-11-linux-x86_64-bin-3.1.0.tgz, rwloadsim-linux-x86_64-bin-3.1.0.tgz, generated-linux-x86_64-bin-3.1.0.tgz (the latter two requires glibc 2.14 or newer)
• A necessary fix was backported after the initial 3.1.0 release, hence the new 3.1.0.3 versions; this fix does not apply to the generated binaries.

Binaries for x86_64 Linux are available for these client environments:

• 11.2 and 12.2 requiring glibc 2.7
• 19 requiring glibc 2.14
• 21 and 23 requiring glibc 2.17

For ARM, 19 client is available requiring glibc 2.17.

These are md5sums:

fcf0725afcd859bb04afcbd273808fd3  generated-11-linux-x86_64-bin-3.1.0.tgz
208c98f4d2d355d23f0ae78482b638e9  generated-linux-x86_64-bin-3.1.0.tgz
daaf645a410ff536f00f69c35f319e40  generated-linux-aarch64-bin-3.1.0.tgz

bf0cc4ae35e787654b24fefa5e8238c1  rwloadsim-linux-aarch64-bin-3.1.0.3.tgz
1e09cd681f4e3556a03d33ba31c7a13a  rwloadsim-linux-aarch64-binonly-3.1.0.3.tgz
db53e0b05c4e2a50527ff1a5f8b6bf09  rwloadsim-linux-x86_64-bin-3.1.0.3.tgz
55397076cf150fafe93c7e446dc4b6d2  rwloadsim-linux-x86_64-binonly-3.1.0.3.tgz

Release 3.0.6 Production

Release 3.0.6 is the last release in the minor 3.0 series, the next release will be 3.1.

In addition to bug fixes, these are the primary changed or new features:

• $pre31fileassign:warn is now default so you will get warnings if you make file assignments to open the file using the := operator and interpretation of the contents of the string. All code should be changed to use one of the new operators like >=, <=, etc.
• A $bindout directive is added allowing embedded and immediate sql to do bindout.
• Whenever a double value is assigned to an integer, an implicit trunc() is applied.
• A few new features have been added, see CHANGELOG.md.

The md5sum values for the binaries are:

6d2e2094c41441157093dba3be5a1494  generated-11-linux-x86_64-bin-3.0.6.tgz
6ddc50d9a960cde3ccd6c8c9e44b8f67  generated-linux-aarch64-bin-3.0.6.tgz
a9f1cd3c1d01f0e59f8cc7ccfeee9126  generated-linux-x86_64-bin-3.0.6.tgz
238d4bb6ec81c6523cf4f59af355c670  rwloadsim-linux-aarch64-bin-3.0.6.tgz
15b815b123ef73e8f63b2e54aacefc4a  rwloadsim-linux-aarch64-binonly-3.0.6.tgz
abfa280a29da1420e852aa41f67f6928  rwloadsim-linux-x86_64-bin-3.0.6.tgz
40a363542b676a28e30778520ef44910  rwloadsim-linux-x86_64-binonly-3.0.6.tgz

Release 3.0.5 Production

Release 3.0.5 is a very minor update from 3.0.4 with only the following changes:

• Rename of awrreport from the previous name awreport
• Small improvements to awrdump
• Minor bugfixes to rwloadsim itself
• Note that if you are upgrading from release 3.0.3 or earlier directly to 3.0.5, the repository upgrade from release 3.0.4 must be executed.

The following new and updated features were made available in Release 3.0.4:

• Heavily updated awrreport and a new awrdump utility to create a dump of an awr repository
• These utilities and the network test utilities can be called directly as shell scripts
• Several bug fixes
• A small repository update found in admin/rwl304.sql must be executed against your repository before running the new release

The following new and updated features were made available in release 3.0.3:

• The syntax for opening files for read, append and as pipelines has been enhanced
• A new database network throughput test, netthroughput.rwl, is included and made available as standalone generated binary
• The ociping and connping utilities have been enhanced

The following new and updated features were included in 3.0.2:

• You can generate an executable with an included rwl script, which can be executed completely stand alone
• 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.
• Several minor updates, a number of bug fixes and updates to the standard oltp workload

The following major new features were included in 3.0.1:

• 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.

Binaries are available for x86_64 Linux; for client environment 11.2 and 12.2, glibc 2.7 is required, for 18 and 19, glibc 2.14 is required, and for 21, glibc 2.17 is required.

ARM binaries based on client release 19.10 and Oracle Linux 8, i.e. requiring glibc 2.17 are made available as beta/development; they should not be used for any Production cases.

In addition to the usual bin and binonly tgz files, the file generated-linux-x86_64-bin-3.0.5.tgz contains stand alone binaries with the rwl scripts ociping.rwl, connping.rwl, netthroughput.rwl, awrreport.rwl, awrdump.rwl. To use either of these, download and un-tar, put the executable anywhere (in your PATH), and run it with -h to get started. An oracle environment release 19 or newer with LD_LIBRARY_PATH properly set is needed; instant client is fine. If you are on an earlier version of either Oracle Linux, glibc or Oracle client environment, the file generated-11-linux-x86_64-bin-3.0.2.4.tgz can be used; it only contains the three Oracle Net utilities, not the awr utilities.

The md5sums of the files are:

8a69e33bc39fae40dce5c9a007dc6ce2  rwloadsim-linux-x86_64-bin-3.0.5.tgz
54273fe4c7de1fadf00e9d995e7e7fce  rwloadsim-linux-x86_64-binonly-3.0.5.tgz
de5c8f0b653fd7651eb344a87b64363a  generated-11-linux-x86_64-bin-3.0.5.tgz
9a16986fd281a6a2e74ee39676fd8f55  generated-linux-x86_64-bin-3.0.5.tgz

eb6974131de4770bca06e50878e0d1d5  generated-linux-aarch64-bin-3.0.5.1.tgz
7af100cc686cb694b75c48d925e8e3fc  rwloadsim-linux-aarch64-bin-3.0.5.1.tgz
e7d1658f8179d9d88b32d0d6adceab2a  rwloadsim-linux-aarch64-binonly-3.0.5.1.tgz

NOTICE: In the two first files, there is a small error in bin/awrreport, that you need to manually correct: The name of the rwl script to be called is still the old name (awreport.rwl), you need to manually change it to awrreport.rwl.

Release 3.0.4 Production

Release 3.0.4 contains the following new and updated features

• Heavily updated awreport and a new awrdump utility to create a dump of an awr repository
• These utilities and the network test utilities can be called directly as shell scripts
• Several bug fixes
• A small repository update found in admin/rwl304.sql must be executed against your repository before running the new release

The following new and updated features were made available in release 3.0.3:

• The syntax for opening files for read, append and as pipelines has been enhanced
• A new database network throughput test, netthroughput.rwl, is included and made available as standalone generated binary
• The ociping and connping utilities have been enhanced

The following new and updated features were included in 3.0.2:

• You can generate an executable with an included rwl script, which can be executed completely stand alone
• 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.
• Several minor updates, a number of bug fixes and updates to the standard oltp workload

Binaries are available for x86_64 Linux; for client environment 11.2 and 12.2, glibc 2.7 is required, for 18 and 19, glibc 2.14 is required, and for 21, glibc 2.17 is required. ARM binaries can be provided upon request.

In addition to the usual bin and binonly tgz files, the file generated-linux-x86_64-bin-3.0.4.tgz contains stand alone binaries with the rwl scripts ociping.rwl, connping.rwl, netthroughput.rwl, awreport.rwl, awrdump.rwl. To use either of these, download and un-tar, put the executable anywhere (in your PATH), and run it with -h to get started. An oracle environment release 19 or newer with LD_LIBRARY_PATH properly set is needed; instant client is fine. If you are on an earlier version of either Oracle Linux, glibc or Oracle client environment, the file generated-11-linux-x86_64-bin-3.0.2.4.tgz can be used; it only contains the three Oracle Net utilities, not the awr utilities.

To verify you downloads, these are the md5sums:

4e5606574141d1dc9ee6381667d38b33  generated-11-linux-x86_64-bin-3.0.4.tgz
d22b216c072db720ac62c825af8e923a  generated-linux-x86_64-bin-3.0.4.tgz
f397cd7f616642961bd95b7b7a095e7c  rwloadsim-linux-x86_64-bin-3.0.4.tgz
734d4c8199020f54d0f5d424a00e24d8  rwloadsim-linux-x86_64-binonly-3.0.4.tgz

Release 3.0.3 Production

Release 3.0.3 includes the following new and updated features

• The syntax for opening files for read, append and as pipelines has been enhanced
• A new database network throughput test, netthroughput.rwl, is included and made available as standalone generated binary
• The ociping and connping utilities have been enhanced

The following new and updated features were included in 3.0.2:

• You can generate an executable with an included rwl script, which can be executed completely stand alone
• 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.
• Several minor updates, a number of bug fixes and updates to the standard oltp workload

Binaries are available for x86_64 Linux; for client environment 11.2 and 12.2, glibc 2.7 is required, for 18 and 19, glibc 2.14 is required, and for 21, glibc 2.17 is required. ARM binaries can be provided upon request.

In addition to the usual bin and binonly tgz files, the file generated-linux-x86_64-bin-3.0.3.tgz contains stand alone binaries with the rwl scripts ociping.rwl, connping.rwl and netthroughput.rwl. To use either of these, download and un-tar, put the executable anywhere (in your PATH), and run it with -h to get started. An oracle environment release 19 or newer with LD_LIBRARY_PATH properly set is needed; instant client is fine. If you are on an earlier version of either Oracle Linux, glibc or Oracle client environment, the file generated-11-linux-x86_64-bin-3.0.2.4.tgz can be used.

The file generated-linux-x86_64-bin-3.0.3.15.tgz is an updated version of the stand alone utilities, which also includes awrerport and awrdump.

For verification, these are md5sum for the three files:

1503e2b71662b77856325c9b286bb48f  generated-11-linux-x86_64-bin-3.0.3.tgz
6d1223b2ce0c5185a053a20a2b2f70b0  generated-linux-x86_64-bin-3.0.3.tgz
f048964ad062dd7b401e4607c085ca22  rwloadsim-linux-x86_64-bin-3.0.3.tgz
ea0b39f93c83e73d5f8486538f09ea20  rwloadsim-linux-x86_64-binonly-3.0.3.tgz
1ed1ce083c4ff4229cec6b7fa768d441 generated-linux-x86_64-bin-3.0.3.15.tgz

Release 3.0.2 Production

Release 3.0.2 includes one new feature in addition to those three included in 3.0.1:

• You can generate an executable with an included rwl script, which can be executed completely stand alone
• 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.
• Several minor updates, a number of bug fixes and updates to the standard oltp workload

Binaries are available for x86_64 Linux; for client environment 11.2 and 12.2, glibc 2.7 is required, for 18 and 19, glibc 2.14 is required, and for 21, glibc 2.17 is required. ARM binaries can be provided upon request.

In addition to the usual bin and binonly tgz files, the file generated-linux-x86_64-bin-3.0.2.tgz contains stand alone binaries with the rwl scripts ociping.rwl and connping.rwl. To use either of these, download and un-tar, put the executable anywhere (in your PATH), and run it with -h to get started. An oracle environment release 19 or newer with LD_LIBRARY_PATH properly set is needed; instant client is fine. If you are on an earlier version of either Oracle Linux, glibc or Oracle client environment, the file generated-11-linux-x86_64-bin-3.0.2.4.tgz can be used.

For verification, these are md5sum for the three files:

a2d968606c4b822753a5f66b8be303f0  generated-linux-x86_64-bin-3.0.2.tgz
c949e04790bda2e56e65d673387344e0  rwloadsim-linux-x86_64-bin-3.0.2.tgz
52ff756fe92f36eccffcd8cbac18d830  rwloadsim-linux-x86_64-binonly-3.0.2.tgz
babe394d36b7420be05c900312dcd0fd  generated-11-linux-x86_64-bin-3.0.2.4.tgz

Release 3.0.1 Production

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.
• Several minor updates, a number of bug fixes and updates to the standard oltp workload

Binaries are available for x86_64 Linux; for client environment 11.1 and 12.2, glibc 2.7 is required, for the others, glibc 2.14 is required. ARM binaries can be provided upon request. In future releases, glibc 2.17 will be required for client environment 21.