oltpxcrun − Execute oltpcore with external control
oltpxcrun [-H] [-g|-G] [-a] [-2] [-k key] [-R file] [-r runperiod] [--no-awr] [--default] [komment text ...]
Continuously make long runs with external control.
-H
Print short help.
-k key
Set the key that will be used when storing results in the repository database. The default is the same as the project name.
-r runperiod
--runperiod runperiod
Set a period for each run in seconds, the default is just under 1h.
--default
The external control values set from a previous run are overwritten by the default values that are found in your {key}.rwl file.
--no-default
This option has no effect; the external control values from previous run are still in effect.
--no-awr
Do not generate awr snapshots, awr report and other run results.
-g|-G
Show graphs during the runs using gnuplot’s output to X-Windows. This requires a properly set DISPLAY environment variable. For -G, see oltprun(2rwl).
-R file
In stead of using the normal run.rwl file count in the oltp directory, use the file named. The primary use of this is for experiments that require modifications to run.rwl.
-a
If your orders and order_items tables are partitioned, you can use the -a option to make sure an empty set of partitions are created at the start of the run. Only use this if the automatic allocation via interval partitions appears to cause trouble
-2
Use side 2 of the aw_transaction workload - needed in special cases only.
The oltpxcrun command is used for demonstration purposes where the ability to modify parameters during the run is important. It does little more than repeatedly doing oltpcore making 3590s long runs. During the run, you can call oltpxcset to modify things; these modifications will be picked up after typically a few seconds.
It is highly recommended that you redirect stderr from oltpxcrun to a file that you show using tail -f.
External control primarily exists for use internally by Oracle Corporation, and it is on purpose vaguely documented. It is not guaranteed that external control will be consistent over time, nor that it will continue to be available. Further, it may impact other parts of the oltp workload, and such impact may change in the future.
Copyright
© 2023 Oracle Corporation
Licensed under the Universal Permissive License v 1.0 as
shown at https://oss.oracle.com/licenses/upl
oltp(2rwl), oltpcore(2rwl), oltpxcset(2rwl)