Package com.oracle.bmc.opsi.model

Class SqlBucket.Builder

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

    • Constructor Detail

      • Builder

        public Builder()

    • Method Detail

      • version

        public SqlBucket.Builder version​(Float version)
        Version Example: 1
        Parameters:
        version - the value to set
        Returns:
        this builder

      • databaseType

        public SqlBucket.Builder databaseType​(String databaseType)
        Ops Insights internal representation of the database type.
        Parameters:
        databaseType - the value to set
        Returns:
        this builder

      • timeCollected

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

      • sqlIdentifier

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

      • planHash

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

      • bucketId

        public SqlBucket.Builder bucketId​(String bucketId)
        SQL Bucket ID, examples <= 3 secs, 3-10 secs, 10-60 secs, 1-5 min, > 5 min Example: “<= 3 secs”
        Parameters:
        bucketId - the value to set
        Returns:
        this builder

      • executionsCount

        public SqlBucket.Builder executionsCount​(Integer executionsCount)
        Total number of executions Example: 60
        Parameters:
        executionsCount - the value to set
        Returns:
        this builder

      • cpuTimeInSec

        public SqlBucket.Builder cpuTimeInSec​(Float cpuTimeInSec)
        Total CPU time Example: 1046
        Parameters:
        cpuTimeInSec - the value to set
        Returns:
        this builder

      • ioTimeInSec

        public SqlBucket.Builder ioTimeInSec​(Float ioTimeInSec)
        Total IO time Example: 5810
        Parameters:
        ioTimeInSec - the value to set
        Returns:
        this builder

      • otherWaitTimeInSec

        public SqlBucket.Builder otherWaitTimeInSec​(Float otherWaitTimeInSec)
        Total other wait time Example: 24061
        Parameters:
        otherWaitTimeInSec - the value to set
        Returns:
        this builder

      • totalTimeInSec

        public SqlBucket.Builder totalTimeInSec​(Float totalTimeInSec)
        Total time Example: 30917
        Parameters:
        totalTimeInSec - the value to set
        Returns:
        this builder