Package com.oracle.bmc.opsi.model

Class SqlStatistics

  • @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).

    • Constructor Detail

      • SqlStatistics

        @Deprecated
@ConstructorProperties({"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)
        Deprecated.

    • Method Detail

      • getDatabaseTimeInSec

        public Double getDatabaseTimeInSec()
        Database Time in seconds
        Returns:
        the value

      • getExecutionsPerHour

        public Double getExecutionsPerHour()
        Number of executions per hour
        Returns:
        the value

      • getExecutionsCount

        public Long getExecutionsCount()
        Total number of executions
        Returns:
        the value

      • getCpuTimeInSec

        public Double getCpuTimeInSec()
        CPU Time in seconds
        Returns:
        the value

      • getIoTimeInSec

        public Double getIoTimeInSec()
        I/O Time in seconds
        Returns:
        the value

      • getInefficientWaitTimeInSec

        public Double getInefficientWaitTimeInSec()
        Inefficient Wait Time in seconds
        Returns:
        the value

      • getResponseTimeInSec

        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

        Returns:
        the value

      • getPlanCount

        public Long getPlanCount()
        Number of SQL execution plans used by the SQL
        Returns:
        the value

      • getVariability

        public Double getVariability()
        Variability is the ratio of the standard deviation in response time to the mean of response time of the SQL
        Returns:
        the value

      • getAverageActiveSessions

        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.

        Returns:
        the value

      • getDatabaseTimePct

        public Double getDatabaseTimePct()
        Percentage of Database Time
        Returns:
        the value

      • getInefficiencyInPct

        public Double getInefficiencyInPct()
        Percentage of Inefficiency.

        It is calculated by Total Database Time divided by Total Wait Time

        Returns:
        the value

      • getChangeInCpuTimeInPct

        public Double getChangeInCpuTimeInPct()
        Percent change in CPU Time based on linear regression
        Returns:
        the value

      • getChangeInIoTimeInPct

        public Double getChangeInIoTimeInPct()
        Percent change in IO Time based on linear regression
        Returns:
        the value

      • getChangeInInefficientWaitTimeInPct

        public Double getChangeInInefficientWaitTimeInPct()
        Percent change in Inefficient Wait Time based on linear regression
        Returns:
        the value

      • getChangeInResponseTimeInPct

        public Double getChangeInResponseTimeInPct()
        Percent change in Response Time based on linear regression
        Returns:
        the value

      • getChangeInAverageActiveSessionsInPct

        public Double getChangeInAverageActiveSessionsInPct()
        Percent change in Average Active Sessions based on linear regression
        Returns:
        the value

      • getChangeInExecutionsPerHourInPct

        public Double getChangeInExecutionsPerHourInPct()
        Percent change in Executions per hour based on linear regression
        Returns:
        the value

      • getChangeInInefficiencyInPct

        public Double getChangeInInefficiencyInPct()
        Percent change in Inefficiency based on linear regression
        Returns:
        the value

      • toString

        public String toString()
        Overrides:
        toString in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

      • toString

        public String toString​(boolean includeByteArrayContents)
        Return a string representation of the object.
        Parameters:
        includeByteArrayContents - true to include the full contents of byte arrays
        Returns:
        string representation

      • equals

        public boolean equals​(Object o)
        Overrides:
        equals in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

      • hashCode

        public int hashCode()
        Overrides:
        hashCode in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel