Package com.oracle.bmc.opsi.model

Class SqlStatistics.Builder

    • 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