histogram − RWP*Load Simulator histogram table and histogram_a, fractiles views
The histogram table and associated views show the distribution of total execution time, which is the sum of the time spent waiting for a session and the time spent execution the actual code of the procedure, over a series of "buckets", each being twice is wide as the previous one.
create table histogram ( runnumber number not null , procno number not null , vname varchar2(30) not null , buckno number not null , bucktim number as (power(2.0,(buckno-19))) virtual , bcount number , ttime number (*,6) , constraint histogram_pk primary key(runnumber, procno, vname, buckno) ) create view histogram_a ( runnumber , pcount , vname , buckno , bucktim , bcount , ttime , atime ) create view fractiles ( runnumber , vname , bucktim , bcount , fractile )
runnumber
This is the number that uniquely identifies a run.
procno pcount
In single process runs, procno is zero, in multi-process runs, it gets its value from the Operating System process number or from the -p option to rwloadsim. In the aggregate view, histogram_a, the total process count is in the pcount column.
vname
This is the name of the procedure being executed.
buckno
The number of this bucket.
bucktim
This bucket covers the range from 0.5*bucktim until bucktim, except the first bucket that covers all positive number until bucktim.
bcount
Number of executions that has a time within the range of this bucket.
ttime
Total time of all executions that are within the range of this bucket.
atime
Average time of all executions that are within the range of this bucket.
fractile
The percentage of executions that are at least as fast as bucktim.
Copyright © 2023 Oracle Corporation
Licensed under the Universal Permissive License v 1.0 as shown at https://oss.oracle.com/licenses/upl