docs/refman/percentiles.html

<!-- Creator     : groff version 1.22.3 -->
<!-- CreationDate: Mon Mar 18 08:51:05 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>percentiles</title>

</head>
<body>

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

<a href="#NAME">NAME</a><br>
<a href="#DECLARATION">DECLARATION</a><br>
<a href="#COLUMNS">COLUMNS</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">rwlman &minus;
RWP*Load Simulator percentiles view</p>

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


<p style="margin-left:11%; margin-top: 1em">The
<b>percentiles</b> view shows execution time limits for
different percentiles of executions of each procedure; the
values can be compared to typical service level agreements
stating that a certain percentage of executions must be
faster than some limit. The time is the sum of the time
spent waiting for a session and the time spent executing the
actual code of the procedure. The time limits for 50%, 90%,
95%, 98%, 99%, 99.5%, 99.8%, 99.9% and 99.95% of executions
are present in the view.</p>

<pre style="margin-left:11%; margin-top: 1em">create view percentiles
( runnumber
, vname
, avgt
, pct50
, pct90
, pct95
, pct98
, pct99
, pct995
, pct998
, pct999
, pct9995
)</pre>


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


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

<p style="margin-left:17%;">This is the number that
uniquely identifies a run.</p>


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

<p style="margin-left:17%;">This is the name of the
procedure being executed.</p>


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

<p style="margin-left:17%;">The average time of all
executions.</p>

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

<p style="margin-left:17%;">The time limit for 50%, etc.
until 99.95% of the executions.</p>

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


<p style="margin-left:11%; margin-top: 1em">The values in
this view are statistical and based on the counts of
executions in each bucket of the histogram_a view. If the
number of executions in a bucket is low, there will be
statistical errors in this calculation.</p>

<p style="margin-left:11%; margin-top: 1em">There is an
additional view <b>percentiles_oltp</b> that is used by the
standard oltp workload; it has the same columns as the
normal percentiles view does. It is created such that it
takes the count of dropped transactions via the time_out
parameter into account.</p>

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


<p style="margin-left:11%; margin-top: 1em">Copyright
&copy; 2023 Oracle Corporation</p>

<p style="margin-left:11%; margin-top: 1em">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="statistics.html">statistics(1rwl)</a>,
<a href="histogram.html">histogram(1rwl)</a></p>
<hr>
</body>
</html>