oltp_outliers

NAME
DECLARATION
COLUMNS
NOTES
COPYRIGHT
SEE ALSO

NAME

oltp_outliers − RWP*Load Simulator OLTP Workload Service Level Agreement limits

DECLARATION

The oltp_outliers table contains the emulated Service Level Agreement limits for execution times of some of the procedures in the standard oltp workload. Each row contains the highest allowed execution time for some percentage of executions of one of the procedures. The time limits for 50%, 90%, 95%, 98%, 99% are saved, and the table is supposed to be joined to the percentiles_oltp view on the vname column. The contents is fixed during initial install (of rwloadsim), and contains experimentally found reasonable values. The user is free to change the actual values as required.

create table oltp_outliers
( vname varchar2(30) not null primary key
, lim50 number
, lim90 number
, lim95 number
, lim98 number
)
/

COLUMNS

vname

The procedure name as defined by the oltp workload.

lim50 ... lim98

The highest allowed time limit for 50%, etc. until 98% of the executions of that procedure. Effectively, if a value in the pctNN column of the percentiles_oltp view is larger than the corresponding limNN column in this table, the service level agreement for NN% of the executions is not fulfilled.

NOTES

The contents of the table is used in several reports generated by the oltp workload such as oltpday(2rwl).

Only data for a subset of the oltp workload procedures are initially included in this table.

COPYRIGHT

Licensed under the Universal Permissive License v 1.0 as shown at https://oss.oracle.com/licenses/upl