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.
- rwlman - Overview of all rwlman pages
- rwloadsim - Calling the rwloadsim executable
- rwlerror - Explaining errors using rwlerror
- rwlprogram - Overview of the rwl language syntax
- multiprocess - Using multiple processes for one simulation
- 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
- directive - All directives
- conditional - Directives for conditional compilation
- include - Directives for include files
- useroption - Directives for user options and switches
- statistics - Overview of statistics gathering
- rwlrun - Overall information about tun
- runres - Execution statistics for each procedure
- persec - Per second throughput
- oerstats - ORA-error statistics
- histogram - Histogram distribution of execution times
- percentiles - Percentile distribution of execution times
- sysres - System statistics gathered by the oltp workload
- rwlcpu - Auxiliary table used by the oltp workload
- oltp - Introduction
- oltpsetup - Setup and preparation
- oltpverify - Verify your setup
- oltpcreate - Create all schemas
- oltpawcols - Recreate the awcols table
- oltpfilloe - Refill the order entry tables
- oltpdrop - Drop all schemas
- oltpcore - Make a single run with stdout/stderr shown on terminal
- oltprun - Make a single run saving stdout/stderr
- oltpplot - Recreate html and graphics for one run
- oltpplus - Start sqlplus as some of your database users
- oltpforever - Start a continuous run
- oltpday - Create a report for a day of oltpforeer
- oltpparams - Show parameters used by oltprun
- oltpcheckkey - Verify some key has not been used before
- oltpscale - Create a scaling run with increasing process count
- oltpscalereport - Recreate the report for a scaling run
- oltpxcrun - Run oltpcore continuously with external control
- oltpxcset - Change behavior of an ongoing oltpxcrun
- awrreport - Create an awr report
- awrdump - Create a dump of awr repository
- ashplot - Create a plot of ash data
- ociping - Run "ping" showing round-trip times to a database
- connping - Run "ping" showing connection and round-trip times to a database
- netthroughput - Estimate Oracle Network throughput
- ovid2 - Generate nice looking random strings
- sqlid2file - Save sql text to a file based on sql_id
- sqlmonitorawr - Create a sqlmonitor from data in awr repository
- sqlmonitor - Create a sqlmonitor from data in gv$ views