docs/refman/oltpxcrun.html

<!-- Creator     : groff version 1.22.3 -->
<!-- CreationDate: Thu Jul  4 09:58:38 2024 -->
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta name="generator" content="groff -Thtml, see www.gnu.org">
<meta http-equiv="Content-Type" content="text/html; charset=US-ASCII">
<meta name="Content-Style" content="text/css">
<style type="text/css">
       p       { margin-top: 0; margin-bottom: 0; vertical-align: top }
       pre     { margin-top: 0; margin-bottom: 0; vertical-align: top }
       table   { margin-top: 0; margin-bottom: 0; vertical-align: top }
       h1      { text-align: center }
</style>
<title>oltpxcrun</title>

</head>
<body>

<h1 align="center">oltpxcrun</h1>

<a href="#NAME">NAME</a><br>
<a href="#SYNOPSIS">SYNOPSIS</a><br>
<a href="#OPTIONS">OPTIONS</a><br>
<a href="#USAGE">USAGE</a><br>
<a href="#NOTES">NOTES</a><br>
<a href="#COPYRIGHT">COPYRIGHT</a><br>
<a href="#SEE ALSO">SEE ALSO</a><br>

<hr>


<h2>NAME
<a name="NAME"></a>
</h2>


<p style="margin-left:11%; margin-top: 1em">oltpxcrun
&minus; Execute oltpcore with external control</p>

<h2>SYNOPSIS
<a name="SYNOPSIS"></a>
</h2>


<p style="margin-left:11%; margin-top: 1em"><b>oltpxcrun
[-H] [-g|-G] [-a] [-2] [-k key] [-R file] [-r runperiod]
[--no-awr] [--default] [komment text ...]</b></p>

<p style="margin-left:11%; margin-top: 1em">Continuously
make long runs with external control.</p>

<h2>OPTIONS
<a name="OPTIONS"></a>
</h2>


<p style="margin-left:11%; margin-top: 1em"><b>-H</b></p>

<p style="margin-left:17%;">Print short help.</p>

<p style="margin-left:11%; margin-top: 1em"><b>-k
key</b></p>

<p style="margin-left:17%;">Set the key that will be used
when storing results in the repository database. The default
is the same as the project name.</p>

<p style="margin-left:11%; margin-top: 1em"><b>-r runperiod
<br>
--runperiod runperiod</b></p>

<p style="margin-left:17%;">Set a period for each run in
seconds, the default is just under 1h.</p>


<p style="margin-left:11%; margin-top: 1em"><b>--default</b></p>

<p style="margin-left:17%;">The external control values set
from a previous run are overwritten by the default values
that are found in your {key}.rwl file.</p>


<p style="margin-left:11%; margin-top: 1em"><b>--no-default</b></p>

<p style="margin-left:17%;">This option has no effect; the
external control values from previous run are still in
effect.</p>


<p style="margin-left:11%; margin-top: 1em"><b>--no-awr</b></p>

<p style="margin-left:17%;">Do not generate awr snapshots,
awr report and other run results.</p>


<p style="margin-left:11%; margin-top: 1em"><b>-g|-G</b></p>

<p style="margin-left:17%;">Show graphs during the runs
using gnuplot&rsquo;s output to X-Windows. This requires a
properly set DISPLAY environment variable. For -G, see
<a href="oltprun.html">oltprun(2rwl)</a>.</p>

<p style="margin-left:11%; margin-top: 1em"><b>-R
file</b></p>

<p style="margin-left:17%;">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.</p>

<p style="margin-left:11%; margin-top: 1em"><b>-a</b></p>

<p style="margin-left:17%;">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</p>

<p style="margin-left:11%; margin-top: 1em"><b>-2</b></p>

<p style="margin-left:17%;">Use side 2 of the
aw_transaction workload - needed in special cases only.</p>

<h2>USAGE
<a name="USAGE"></a>
</h2>


<p style="margin-left:11%; margin-top: 1em">The
<b>oltpxcrun</b> command is used for demonstration purposes
where the ability to modify parameters during the run is
important. It does little more than repeatedly doing
<b>oltpcore</b> 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.</p>

<p style="margin-left:11%; margin-top: 1em">It is highly
recommended that you redirect stderr from oltpxcrun to a
file that you show using tail -f.</p>

<h2>NOTES
<a name="NOTES"></a>
</h2>


<p style="margin-left:11%; margin-top: 1em">External
control primarily exists for use internally by Oracle
Corporation, and it is on purpose vaguely documented. It is
<i>not</i> 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.</p>

<h2>COPYRIGHT
<a name="COPYRIGHT"></a>
</h2>


<p style="margin-left:11%; margin-top: 1em">Copyright
&copy; 2023 Oracle Corporation <br>
Licensed under the Universal Permissive License v 1.0 as
shown at https://oss.oracle.com/licenses/upl</p>

<h2>SEE ALSO
<a name="SEE ALSO"></a>
</h2>


<p style="margin-left:11%; margin-top: 1em"><a href="oltp.html">oltp(2rwl)</a>,
<a href="oltpcore.html">oltpcore(2rwl)</a>, <a href="oltpxcset.html">oltpxcset(2rwl)</a></p>
<hr>
</body>
</html>