@Generated(value="OracleSDKGenerator",
comments="API Version: 20200630")
public final class SqlStatistics
extends com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
Performance statistics for the SQL.
Note: Objects should always be created or deserialized using the SqlStatistics.Builder. This model
distinguishes fields that are null because they are unset from fields that are explicitly
set to null. This is done in the setter methods of the SqlStatistics.Builder, which maintain a
set of all explicitly set fields called SqlStatistics.Builder.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take the explicitly set
fields into account. The constructor, on the other hand, does not take the explicitly set fields
into account (since the constructor cannot distinguish explicit null from unset null).
| Modifier and Type | Class and Description |
|---|---|
static class |
SqlStatistics.Builder |
EXPLICITLY_SET_FILTER_NAME, EXPLICITLY_SET_PROPERTY_NAME| Constructor and Description |
|---|
SqlStatistics(Double databaseTimeInSec,
Double executionsPerHour,
Long executionsCount,
Double cpuTimeInSec,
Double ioTimeInSec,
Double inefficientWaitTimeInSec,
Double responseTimeInSec,
Long planCount,
Double variability,
Double averageActiveSessions,
Double databaseTimePct,
Double inefficiencyInPct,
Double changeInCpuTimeInPct,
Double changeInIoTimeInPct,
Double changeInInefficientWaitTimeInPct,
Double changeInResponseTimeInPct,
Double changeInAverageActiveSessionsInPct,
Double changeInExecutionsPerHourInPct,
Double changeInInefficiencyInPct)
Deprecated.
|
| Modifier and Type | Method and Description |
|---|---|
static SqlStatistics.Builder |
builder()
Create a new builder.
|
boolean |
equals(Object o) |
Double |
getAverageActiveSessions()
Average Active Sessions represent the average active sessions at a point in time.
|
Double |
getChangeInAverageActiveSessionsInPct()
Percent change in Average Active Sessions based on linear regression
|
Double |
getChangeInCpuTimeInPct()
Percent change in CPU Time based on linear regression
|
Double |
getChangeInExecutionsPerHourInPct()
Percent change in Executions per hour based on linear regression
|
Double |
getChangeInInefficiencyInPct()
Percent change in Inefficiency based on linear regression
|
Double |
getChangeInInefficientWaitTimeInPct()
Percent change in Inefficient Wait Time based on linear regression
|
Double |
getChangeInIoTimeInPct()
Percent change in IO Time based on linear regression
|
Double |
getChangeInResponseTimeInPct()
Percent change in Response Time based on linear regression
|
Double |
getCpuTimeInSec()
CPU Time in seconds
|
Double |
getDatabaseTimeInSec()
Database Time in seconds
|
Double |
getDatabaseTimePct()
Percentage of Database Time
|
Long |
getExecutionsCount()
Total number of executions
|
Double |
getExecutionsPerHour()
Number of executions per hour
|
Double |
getInefficiencyInPct()
Percentage of Inefficiency.
|
Double |
getInefficientWaitTimeInSec()
Inefficient Wait Time in seconds
|
Double |
getIoTimeInSec()
I/O Time in seconds
|
Long |
getPlanCount()
Number of SQL execution plans used by the SQL
|
Double |
getResponseTimeInSec()
Response time is the average elaspsed time per execution.
|
Double |
getVariability()
Variability is the ratio of the standard deviation in response time to the mean of response
time of the SQL
|
int |
hashCode() |
SqlStatistics.Builder |
toBuilder() |
String |
toString() |
String |
toString(boolean includeByteArrayContents)
Return a string representation of the object.
|
markPropertyAsExplicitlySet, wasPropertyExplicitlySet@Deprecated @ConstructorProperties(value={"databaseTimeInSec","executionsPerHour","executionsCount","cpuTimeInSec","ioTimeInSec","inefficientWaitTimeInSec","responseTimeInSec","planCount","variability","averageActiveSessions","databaseTimePct","inefficiencyInPct","changeInCpuTimeInPct","changeInIoTimeInPct","changeInInefficientWaitTimeInPct","changeInResponseTimeInPct","changeInAverageActiveSessionsInPct","changeInExecutionsPerHourInPct","changeInInefficiencyInPct"}) public SqlStatistics(Double databaseTimeInSec, Double executionsPerHour, Long executionsCount, Double cpuTimeInSec, Double ioTimeInSec, Double inefficientWaitTimeInSec, Double responseTimeInSec, Long planCount, Double variability, Double averageActiveSessions, Double databaseTimePct, Double inefficiencyInPct, Double changeInCpuTimeInPct, Double changeInIoTimeInPct, Double changeInInefficientWaitTimeInPct, Double changeInResponseTimeInPct, Double changeInAverageActiveSessionsInPct, Double changeInExecutionsPerHourInPct, Double changeInInefficiencyInPct)
public static SqlStatistics.Builder builder()
Create a new builder.
public SqlStatistics.Builder toBuilder()
public Double getDatabaseTimeInSec()
Database Time in seconds
public Double getExecutionsPerHour()
Number of executions per hour
public Long getExecutionsCount()
Total number of executions
public Double getCpuTimeInSec()
CPU Time in seconds
public Double getIoTimeInSec()
I/O Time in seconds
public Double getInefficientWaitTimeInSec()
Inefficient Wait Time in seconds
public Double getResponseTimeInSec()
Response time is the average elaspsed time per execution. It is the ratio of Total Database Time to the number of executions
public Long getPlanCount()
Number of SQL execution plans used by the SQL
public Double getVariability()
Variability is the ratio of the standard deviation in response time to the mean of response time of the SQL
public Double getAverageActiveSessions()
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.
public Double getDatabaseTimePct()
Percentage of Database Time
public Double getInefficiencyInPct()
Percentage of Inefficiency. It is calculated by Total Database Time divided by Total Wait Time
public Double getChangeInCpuTimeInPct()
Percent change in CPU Time based on linear regression
public Double getChangeInIoTimeInPct()
Percent change in IO Time based on linear regression
public Double getChangeInInefficientWaitTimeInPct()
Percent change in Inefficient Wait Time based on linear regression
public Double getChangeInResponseTimeInPct()
Percent change in Response Time based on linear regression
public Double getChangeInAverageActiveSessionsInPct()
Percent change in Average Active Sessions based on linear regression
public Double getChangeInExecutionsPerHourInPct()
Percent change in Executions per hour based on linear regression
public Double getChangeInInefficiencyInPct()
Percent change in Inefficiency based on linear regression
public String toString()
toString in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModelpublic String toString(boolean includeByteArrayContents)
Return a string representation of the object.
includeByteArrayContents - true to include the full contents of byte arrayspublic boolean equals(Object o)
equals in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModelpublic int hashCode()
hashCode in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModelCopyright © 2016–2024. All rights reserved.