RWP*Load Simulator reference manual
This is rwloadsim reference manual including both the tool itself,
the programming language, the supplied oltp workload, and
all other included rwl scripts and files.
For online reading, you must use the link
https://oracle.github.io/rwloadsim/refman/.
If you are reading from github.com, you will see the hmtl source in stead of
the formatted version.
After installation, the reference manual will be available as
rwlman pages that are very similar to ordinary man pages.
You can simply type rwlman to get started.
Introduction to rwloadsim
Language syntax
- simpledeclaration - Variable declaration in general
- expression - Expressions, constants, precedence rules, standard function
- identifier - Identifier syntax and list of predefined variables
- statement - Execution of simple statements, assignments
- database - Overview of databases and sql
- databasedeclaration - Declaring databases
- sqldeclaration - Declaring static and dynamic SQL and PL/SQL
- sqlexecution - Executing SQL, PL/SQL or cursor loops
- sqlstatement - Changing properties of sql
- databasestatement - Performing operations on databases, transactions, lob
- atclause - Choosing a particular database
- compoundstatement - Compound statements, if/then/else, loops
- controlloop - Use the controlloop to specify workload
- declaration - Overview of complex declarations
- proceduredeclaration - Declaring procedures and functions
- randomproceduredeclaration - Declaring random procedures
- randomstringdeclaration - Declaring random strings
- filestatement - Use of operating system files, pipe-lines
- printfstatement - How to use printf, fprintf or sprintf for output formatting
- lobdeclaration - Declaring LOB variables
- regex - Use of regular expressions
- threadexecution - Using multiple threads for simulation
Directives
Statistics tables and views
OLTP workload
Utilities and include files