utilities − RWP*Load Simulator overview of utilities
The RWP*Load Simulator installation includes a number of utilities that are rwl scripts found in the public directory. This page gives an overview of these.
ociping †
Similar to the normal ping command but showing the time to perform an Oracle Net (SQL*Net) round-trip.
connping †
Similar to ociping, but also showing the time taken to perform a database logon.
netthroughput †
Perform a test of the network throughput from a database to your client.
sqlid2file
Extract SQL statement text from either gv$sql or from the awr repository and write it to a text file.
sqlreport
Create a detailed sql report using dbms_sqltune.report_sql_detail.
sqlmonitor
Extract a sqlmonitor into an html file from the contents of gv$sql views.
sqlmonitorawr
Extract a sqlmonitor into an html file from the contents of the awr repository.
awrreport †
Create an awr or ash report from the contents of the awr repository. This is e.g. very useful if you do not have access to an Oracle database server installation, and therefore do not have the scripts in the $ORACLE_HOME/rdbms/admin directory normally used for this purpose.
awrdump †
Make an extract of the awr repository as a data pump file and potentially copy the file an Oracle Cloud Infrastructure storage bucket.
ashplot †
Create a plot of ash data from the contents of the awr repository or from gv$active_session_history. The plot can be created as a png or svg image file, or directly to your screen if you have an X11 environment. You must have gnuplot available to do this.
These utilities are all shipped as rwl files in the public directory of your rwloadsim distribution. You therefore need to provide the -u option to rwloadsim and the name of the wanted utility including the .rwl file suffix. For all practical purposes you also need to provide a default database using the -l option.
In addition to being available as .rwl files, those marked with † are also available as executable shell scripts in the bin directory. The shell scripts do little more than calling rwloadsim with the -u option and the name of the .rwl file. For those available as shell scripts, the two calls:
utility -l u/p@c [options] rwloadsim -l u/p@c [options] -u utility.rwl
are for all practical purposes identical and both can be used.
Copyright © 2023 Oracle Corporation
Licensed under the Universal Permissive License v 1.0 as shown at https://oss.oracle.com/licenses/upl
rwloadsim(1rwl), ociping(2rwl), connping(2rwl), netthroughput(2rwl), sqlreport(2rwl), sqlmonitor(2rwl), sqlmonitorawr(2rwl), sqlid2file(2rwl), awrreport(2rwl), awrdump(2rwl), ashplot(2rwl), filecommands(2rwl)