Package com.oracle.bmc.opsi.model

Class SqlStats.Builder

  • Enclosing class:
    SqlStats
    public static class SqlStats.Builder
extends Object

    • Constructor Detail

      • Builder

        public Builder()

    • Method Detail

      • sqlIdentifier

        public SqlStats.Builder sqlIdentifier​(String sqlIdentifier)
        Unique SQL_ID for a SQL Statement.
        Parameters:
        sqlIdentifier - the value to set
        Returns:
        this builder

      • planHashValue

        public SqlStats.Builder planHashValue​(Long planHashValue)
        Plan hash value for the SQL Execution Plan
        Parameters:
        planHashValue - the value to set
        Returns:
        this builder

      • timeCollected

        public SqlStats.Builder timeCollected​(Date timeCollected)
        Collection timestamp Example: “2020-03-31T00:00:00.000Z”
        Parameters:
        timeCollected - the value to set
        Returns:
        this builder

      • instanceName

        public SqlStats.Builder instanceName​(String instanceName)
        Name of Database Instance Example: “DB10902_1”
        Parameters:
        instanceName - the value to set
        Returns:
        this builder

      • lastActiveTime

        public SqlStats.Builder lastActiveTime​(String lastActiveTime)
        last_active_time Example: “0000000099CCE300”
        Parameters:
        lastActiveTime - the value to set
        Returns:
        this builder

      • parseCalls

        public SqlStats.Builder parseCalls​(Long parseCalls)
        Total integer of parse calls Example: 60
        Parameters:
        parseCalls - the value to set
        Returns:
        this builder

      • diskReads

        public SqlStats.Builder diskReads​(Long diskReads)
        Number of disk reads
        Parameters:
        diskReads - the value to set
        Returns:
        this builder

      • directReads

        public SqlStats.Builder directReads​(Long directReads)
        Number of direct reads
        Parameters:
        directReads - the value to set
        Returns:
        this builder

      • directWrites

        public SqlStats.Builder directWrites​(Long directWrites)
        Number of Direct writes
        Parameters:
        directWrites - the value to set
        Returns:
        this builder

      • bufferGets

        public SqlStats.Builder bufferGets​(Long bufferGets)
        Number of Buffer Gets
        Parameters:
        bufferGets - the value to set
        Returns:
        this builder

      • rowsProcessed

        public SqlStats.Builder rowsProcessed​(Long rowsProcessed)
        Number of row processed
        Parameters:
        rowsProcessed - the value to set
        Returns:
        this builder

      • serializableAborts

        public SqlStats.Builder serializableAborts​(Long serializableAborts)
        Number of serializable aborts
        Parameters:
        serializableAborts - the value to set
        Returns:
        this builder

      • fetches

        public SqlStats.Builder fetches​(Long fetches)
        Number of fetches
        Parameters:
        fetches - the value to set
        Returns:
        this builder

      • executions

        public SqlStats.Builder executions​(Long executions)
        Number of executions
        Parameters:
        executions - the value to set
        Returns:
        this builder

      • avoidedExecutions

        public SqlStats.Builder avoidedExecutions​(Long avoidedExecutions)
        Number of executions attempted on this object, but prevented due to the SQL statement being in quarantine
        Parameters:
        avoidedExecutions - the value to set
        Returns:
        this builder

      • endOfFetchCount

        public SqlStats.Builder endOfFetchCount​(Long endOfFetchCount)
        Number of times this cursor was fully executed since the cursor was brought into the library cache
        Parameters:
        endOfFetchCount - the value to set
        Returns:
        this builder

      • loads

        public SqlStats.Builder loads​(Long loads)
        Number of times the object was either loaded or reloaded
        Parameters:
        loads - the value to set
        Returns:
        this builder

      • versionCount

        public SqlStats.Builder versionCount​(Long versionCount)
        Number of cursors present in the cache with this SQL text and plan
        Parameters:
        versionCount - the value to set
        Returns:
        this builder

      • invalidations

        public SqlStats.Builder invalidations​(Long invalidations)
        Number of times this child cursor has been invalidated
        Parameters:
        invalidations - the value to set
        Returns:
        this builder

      • obsoleteCount

        public SqlStats.Builder obsoleteCount​(Long obsoleteCount)
        Number of times that a parent cursor became obsolete
        Parameters:
        obsoleteCount - the value to set
        Returns:
        this builder

      • pxServersExecutions

        public SqlStats.Builder pxServersExecutions​(Long pxServersExecutions)
        Total number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel)
        Parameters:
        pxServersExecutions - the value to set
        Returns:
        this builder

      • cpuTimeInUs

        public SqlStats.Builder cpuTimeInUs​(Long cpuTimeInUs)
        CPU time (in microseconds) used by this cursor for parsing, executing, and fetching
        Parameters:
        cpuTimeInUs - the value to set
        Returns:
        this builder

      • elapsedTimeInUs

        public SqlStats.Builder elapsedTimeInUs​(Long elapsedTimeInUs)
        Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching.
        Parameters:
        elapsedTimeInUs - the value to set
        Returns:
        this builder

      • avgHardParseTimeInUs

        public SqlStats.Builder avgHardParseTimeInUs​(Long avgHardParseTimeInUs)
        Average hard parse time (in microseconds) used by this cursor
        Parameters:
        avgHardParseTimeInUs - the value to set
        Returns:
        this builder

      • concurrencyWaitTimeInUs

        public SqlStats.Builder concurrencyWaitTimeInUs​(Long concurrencyWaitTimeInUs)
        Concurrency wait time (in microseconds)
        Parameters:
        concurrencyWaitTimeInUs - the value to set
        Returns:
        this builder

      • applicationWaitTimeInUs

        public SqlStats.Builder applicationWaitTimeInUs​(Long applicationWaitTimeInUs)
        Application wait time (in microseconds)
        Parameters:
        applicationWaitTimeInUs - the value to set
        Returns:
        this builder

      • clusterWaitTimeInUs

        public SqlStats.Builder clusterWaitTimeInUs​(Long clusterWaitTimeInUs)
        Cluster wait time (in microseconds).

        This value is specific to Oracle RAC

        Parameters:
        clusterWaitTimeInUs - the value to set
        Returns:
        this builder

      • userIoWaitTimeInUs

        public SqlStats.Builder userIoWaitTimeInUs​(Long userIoWaitTimeInUs)
        User I/O wait time (in microseconds)
        Parameters:
        userIoWaitTimeInUs - the value to set
        Returns:
        this builder

      • plsqlExecTimeInUs

        public SqlStats.Builder plsqlExecTimeInUs​(Long plsqlExecTimeInUs)
        PL/SQL execution time (in microseconds)
        Parameters:
        plsqlExecTimeInUs - the value to set
        Returns:
        this builder

      • javaExecTimeInUs

        public SqlStats.Builder javaExecTimeInUs​(Long javaExecTimeInUs)
        Java execution time (in microseconds)
        Parameters:
        javaExecTimeInUs - the value to set
        Returns:
        this builder

      • sorts

        public SqlStats.Builder sorts​(Long sorts)
        Number of sorts that were done for the child cursor
        Parameters:
        sorts - the value to set
        Returns:
        this builder

      • sharableMem

        public SqlStats.Builder sharableMem​(Long sharableMem)
        Total shared memory (in bytes) currently occupied by all cursors with this SQL text and plan
        Parameters:
        sharableMem - the value to set
        Returns:
        this builder

      • totalSharableMem

        public SqlStats.Builder totalSharableMem​(Long totalSharableMem)
        Total shared memory (in bytes) occupied by all cursors with this SQL text and plan if they were to be fully loaded in the shared pool (that is, cursor size)
        Parameters:
        totalSharableMem - the value to set
        Returns:
        this builder

      • typeCheckMem

        public SqlStats.Builder typeCheckMem​(Long typeCheckMem)
        Typecheck memory
        Parameters:
        typeCheckMem - the value to set
        Returns:
        this builder

      • ioCellOffloadEligibleBytes

        public SqlStats.Builder ioCellOffloadEligibleBytes​(Long ioCellOffloadEligibleBytes)
        Number of I/O bytes which can be filtered by the Exadata storage system
        Parameters:
        ioCellOffloadEligibleBytes - the value to set
        Returns:
        this builder

      • ioInterconnectBytes

        public SqlStats.Builder ioInterconnectBytes​(Long ioInterconnectBytes)
        Number of I/O bytes exchanged between Oracle Database and the storage system.

        Typically used for Cache Fusion or parallel queries

        Parameters:
        ioInterconnectBytes - the value to set
        Returns:
        this builder

      • physicalReadRequests

        public SqlStats.Builder physicalReadRequests​(Long physicalReadRequests)
        Number of physical read I/O requests issued by the monitored SQL.

        The requests may not be disk reads

        Parameters:
        physicalReadRequests - the value to set
        Returns:
        this builder

      • physicalReadBytes

        public SqlStats.Builder physicalReadBytes​(Long physicalReadBytes)
        Number of bytes read from disks by the monitored SQL
        Parameters:
        physicalReadBytes - the value to set
        Returns:
        this builder

      • physicalWriteRequests

        public SqlStats.Builder physicalWriteRequests​(Long physicalWriteRequests)
        Number of physical write I/O requests issued by the monitored SQL
        Parameters:
        physicalWriteRequests - the value to set
        Returns:
        this builder

      • physicalWriteBytes

        public SqlStats.Builder physicalWriteBytes​(Long physicalWriteBytes)
        Number of bytes written to disks by the monitored SQL
        Parameters:
        physicalWriteBytes - the value to set
        Returns:
        this builder

      • exactMatchingSignature

        public SqlStats.Builder exactMatchingSignature​(String exactMatchingSignature)
        exact_matching_signature Example: “18067345456756876713”
        Parameters:
        exactMatchingSignature - the value to set
        Returns:
        this builder

      • forceMatchingSignature

        public SqlStats.Builder forceMatchingSignature​(String forceMatchingSignature)
        force_matching_signature Example: “18067345456756876713”
        Parameters:
        forceMatchingSignature - the value to set
        Returns:
        this builder

      • ioCellUncompressedBytes

        public SqlStats.Builder ioCellUncompressedBytes​(Long ioCellUncompressedBytes)
        Number of uncompressed bytes (that is, size after decompression) that are offloaded to the Exadata cells
        Parameters:
        ioCellUncompressedBytes - the value to set
        Returns:
        this builder

      • ioCellOffloadReturnedBytes

        public SqlStats.Builder ioCellOffloadReturnedBytes​(Long ioCellOffloadReturnedBytes)
        Number of bytes that are returned by Exadata cell through the regular I/O path
        Parameters:
        ioCellOffloadReturnedBytes - the value to set
        Returns:
        this builder

      • childNumber

        public SqlStats.Builder childNumber​(Long childNumber)
        Number of this child cursor
        Parameters:
        childNumber - the value to set
        Returns:
        this builder

      • commandType

        public SqlStats.Builder commandType​(Long commandType)
        Oracle command type definition
        Parameters:
        commandType - the value to set
        Returns:
        this builder

      • usersOpening

        public SqlStats.Builder usersOpening​(Long usersOpening)
        Number of users that have any of the child cursors open
        Parameters:
        usersOpening - the value to set
        Returns:
        this builder

      • usersExecuting

        public SqlStats.Builder usersExecuting​(Long usersExecuting)
        Number of users executing the statement
        Parameters:
        usersExecuting - the value to set
        Returns:
        this builder

      • optimizerCost

        public SqlStats.Builder optimizerCost​(Long optimizerCost)
        Cost of this query given by the optimizer
        Parameters:
        optimizerCost - the value to set
        Returns:
        this builder

      • fullPlanHashValue

        public SqlStats.Builder fullPlanHashValue​(String fullPlanHashValue)
        Total Number of rows in SQLStats table
        Parameters:
        fullPlanHashValue - the value to set
        Returns:
        this builder

      • module

        public SqlStats.Builder module​(String module)
        Module name
        Parameters:
        module - the value to set
        Returns:
        this builder

      • service

        public SqlStats.Builder service​(String service)
        Service name
        Parameters:
        service - the value to set
        Returns:
        this builder

      • action

        public SqlStats.Builder action​(String action)
        Contains the name of the action that was executing when the SQL statement was first parsed, which is set by calling DBMS_APPLICATION_INFO.SET_ACTION
        Parameters:
        action - the value to set
        Returns:
        this builder

      • sqlProfile

        public SqlStats.Builder sqlProfile​(String sqlProfile)
        SQL profile used for this statement, if any
        Parameters:
        sqlProfile - the value to set
        Returns:
        this builder

      • sqlPatch

        public SqlStats.Builder sqlPatch​(String sqlPatch)
        SQL patch used for this statement, if any
        Parameters:
        sqlPatch - the value to set
        Returns:
        this builder

      • sqlPlanBaseline

        public SqlStats.Builder sqlPlanBaseline​(String sqlPlanBaseline)
        SQL plan baseline used for this statement, if any
        Parameters:
        sqlPlanBaseline - the value to set
        Returns:
        this builder

      • deltaExecutionCount

        public SqlStats.Builder deltaExecutionCount​(Long deltaExecutionCount)
        Number of executions for the cursor since the last AWR snapshot
        Parameters:
        deltaExecutionCount - the value to set
        Returns:
        this builder

      • deltaCpuTime

        public SqlStats.Builder deltaCpuTime​(Long deltaCpuTime)
        CPU time (in microseconds) for the cursor since the last AWR snapshot
        Parameters:
        deltaCpuTime - the value to set
        Returns:
        this builder

      • deltaIoBytes

        public SqlStats.Builder deltaIoBytes​(Long deltaIoBytes)
        Number of I/O bytes exchanged between the Oracle database and the storage system for the cursor since the last AWR snapshot
        Parameters:
        deltaIoBytes - the value to set
        Returns:
        this builder

      • deltaCpuRank

        public SqlStats.Builder deltaCpuRank​(Long deltaCpuRank)
        Rank based on CPU Consumption
        Parameters:
        deltaCpuRank - the value to set
        Returns:
        this builder

      • deltaExecsRank

        public SqlStats.Builder deltaExecsRank​(Long deltaExecsRank)
        Rank based on number of execution
        Parameters:
        deltaExecsRank - the value to set
        Returns:
        this builder

      • sharableMemRank

        public SqlStats.Builder sharableMemRank​(Long sharableMemRank)
        Rank based on sharable memory
        Parameters:
        sharableMemRank - the value to set
        Returns:
        this builder

      • deltaIoRank

        public SqlStats.Builder deltaIoRank​(Long deltaIoRank)
        Rank based on I/O Consumption
        Parameters:
        deltaIoRank - the value to set
        Returns:
        this builder

      • harmonicSum

        public SqlStats.Builder harmonicSum​(Long harmonicSum)
        Harmonic sum based on ranking parameters
        Parameters:
        harmonicSum - the value to set
        Returns:
        this builder

      • wtHarmonicSum

        public SqlStats.Builder wtHarmonicSum​(Long wtHarmonicSum)
        Weight based harmonic sum of ranking parameters
        Parameters:
        wtHarmonicSum - the value to set
        Returns:
        this builder

      • totalSqlCount

        public SqlStats.Builder totalSqlCount​(Long totalSqlCount)
        Total number of rows in SQLStats table
        Parameters:
        totalSqlCount - the value to set
        Returns:
        this builder