com.oracle.bmc.opsi.model

Class SqlStatistics.Builder

java.lang.Object

com.oracle.bmc.opsi.model.SqlStatistics.Builder

Enclosing class:

SqlStatistics

public static class SqlStatistics.Builder
extends Object

Constructor Summary

Constructors

Constructor and Description
Builder()

Method Summary

Modifier and Type	Method and Description
SqlStatistics.Builder	averageActiveSessions(Double averageActiveSessions) Average Active Sessions represent the average active sessions at a point in time.
SqlStatistics	build()
SqlStatistics.Builder	changeInAverageActiveSessionsInPct(Double changeInAverageActiveSessionsInPct) Percent change in Average Active Sessions based on linear regression
SqlStatistics.Builder	changeInCpuTimeInPct(Double changeInCpuTimeInPct) Percent change in CPU Time based on linear regression
SqlStatistics.Builder	changeInExecutionsPerHourInPct(Double changeInExecutionsPerHourInPct) Percent change in Executions per hour based on linear regression
SqlStatistics.Builder	changeInInefficiencyInPct(Double changeInInefficiencyInPct) Percent change in Inefficiency based on linear regression
SqlStatistics.Builder	changeInInefficientWaitTimeInPct(Double changeInInefficientWaitTimeInPct) Percent change in Inefficient Wait Time based on linear regression
SqlStatistics.Builder	changeInIoTimeInPct(Double changeInIoTimeInPct) Percent change in IO Time based on linear regression
SqlStatistics.Builder	changeInResponseTimeInPct(Double changeInResponseTimeInPct) Percent change in Response Time based on linear regression
SqlStatistics.Builder	copy(SqlStatistics model)
SqlStatistics.Builder	cpuTimeInSec(Double cpuTimeInSec) CPU Time in seconds
SqlStatistics.Builder	databaseTimeInSec(Double databaseTimeInSec) Database Time in seconds
SqlStatistics.Builder	databaseTimePct(Double databaseTimePct) Percentage of Database Time
SqlStatistics.Builder	executionsCount(Long executionsCount) Total number of executions
SqlStatistics.Builder	executionsPerHour(Double executionsPerHour) Number of executions per hour
SqlStatistics.Builder	inefficiencyInPct(Double inefficiencyInPct) Percentage of Inefficiency.
SqlStatistics.Builder	inefficientWaitTimeInSec(Double inefficientWaitTimeInSec) Inefficient Wait Time in seconds
SqlStatistics.Builder	ioTimeInSec(Double ioTimeInSec) I/O Time in seconds
SqlStatistics.Builder	planCount(Long planCount) Number of SQL execution plans used by the SQL
SqlStatistics.Builder	responseTimeInSec(Double responseTimeInSec) Response time is the average elaspsed time per execution.
SqlStatistics.Builder	variability(Double variability) Variability is the ratio of the standard deviation in response time to the mean of response time of the SQL

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Builder

public Builder()

Method Detail

databaseTimeInSec

public SqlStatistics.Builder databaseTimeInSec(Double databaseTimeInSec)

Database Time in seconds

Parameters:

databaseTimeInSec - the value to set

Returns:

this builder

executionsPerHour

public SqlStatistics.Builder executionsPerHour(Double executionsPerHour)

Number of executions per hour

Parameters:

executionsPerHour - the value to set

Returns:

this builder

executionsCount

public SqlStatistics.Builder executionsCount(Long executionsCount)

Total number of executions

Parameters:

executionsCount - the value to set

Returns:

this builder

cpuTimeInSec

public SqlStatistics.Builder cpuTimeInSec(Double cpuTimeInSec)

CPU Time in seconds

Parameters:

cpuTimeInSec - the value to set

Returns:

this builder

ioTimeInSec

public SqlStatistics.Builder ioTimeInSec(Double ioTimeInSec)

I/O Time in seconds

Parameters:

ioTimeInSec - the value to set

Returns:

this builder

inefficientWaitTimeInSec

public SqlStatistics.Builder inefficientWaitTimeInSec(Double inefficientWaitTimeInSec)

Inefficient Wait Time in seconds

Parameters:

inefficientWaitTimeInSec - the value to set

Returns:

this builder

responseTimeInSec

public SqlStatistics.Builder responseTimeInSec(Double responseTimeInSec)

Response time is the average elaspsed time per execution. It is the ratio of Total Database Time to the number of executions

Parameters:

responseTimeInSec - the value to set

Returns:

this builder

planCount

public SqlStatistics.Builder planCount(Long planCount)

Number of SQL execution plans used by the SQL

Parameters:

planCount - the value to set

Returns:

this builder

variability

public SqlStatistics.Builder variability(Double variability)

Variability is the ratio of the standard deviation in response time to the mean of response time of the SQL

Parameters:

variability - the value to set

Returns:

this builder

averageActiveSessions

public SqlStatistics.Builder averageActiveSessions(Double averageActiveSessions)

Average Active Sessions represent the average active sessions at a point in time. It is the number of sessions that are either working or waiting.

Parameters:

averageActiveSessions - the value to set

Returns:

this builder

databaseTimePct

public SqlStatistics.Builder databaseTimePct(Double databaseTimePct)

Percentage of Database Time

Parameters:

databaseTimePct - the value to set

Returns:

this builder

inefficiencyInPct

public SqlStatistics.Builder inefficiencyInPct(Double inefficiencyInPct)

Percentage of Inefficiency. It is calculated by Total Database Time divided by Total Wait Time

Parameters:

inefficiencyInPct - the value to set

Returns:

this builder

changeInCpuTimeInPct

public SqlStatistics.Builder changeInCpuTimeInPct(Double changeInCpuTimeInPct)

Percent change in CPU Time based on linear regression

Parameters:

changeInCpuTimeInPct - the value to set

Returns:

this builder

changeInIoTimeInPct

public SqlStatistics.Builder changeInIoTimeInPct(Double changeInIoTimeInPct)

Percent change in IO Time based on linear regression

Parameters:

changeInIoTimeInPct - the value to set

Returns:

this builder

changeInInefficientWaitTimeInPct

public SqlStatistics.Builder changeInInefficientWaitTimeInPct(Double changeInInefficientWaitTimeInPct)

Percent change in Inefficient Wait Time based on linear regression

Parameters:

changeInInefficientWaitTimeInPct - the value to set

Returns:

this builder

changeInResponseTimeInPct

public SqlStatistics.Builder changeInResponseTimeInPct(Double changeInResponseTimeInPct)

Percent change in Response Time based on linear regression

Parameters:

changeInResponseTimeInPct - the value to set

Returns:

this builder

changeInAverageActiveSessionsInPct

public SqlStatistics.Builder changeInAverageActiveSessionsInPct(Double changeInAverageActiveSessionsInPct)

Percent change in Average Active Sessions based on linear regression

Parameters:

changeInAverageActiveSessionsInPct - the value to set

Returns:

this builder

changeInExecutionsPerHourInPct

public SqlStatistics.Builder changeInExecutionsPerHourInPct(Double changeInExecutionsPerHourInPct)

Percent change in Executions per hour based on linear regression

Parameters:

changeInExecutionsPerHourInPct - the value to set

Returns:

this builder

changeInInefficiencyInPct

public SqlStatistics.Builder changeInInefficiencyInPct(Double changeInInefficiencyInPct)

Percent change in Inefficiency based on linear regression

Parameters:

changeInInefficiencyInPct - the value to set

Returns:

this builder

build

public SqlStatistics build()

copy

public SqlStatistics.Builder copy(SqlStatistics model)