Package com.oracle.bmc.opsi.model

Class SqlPlanLine.Builder

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

    • Constructor Detail

      • Builder

        public Builder()

    • Method Detail

      • version

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

      • sqlIdentifier

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

      • planHash

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

      • forceMatchingSignature

        public SqlPlanLine.Builder forceMatchingSignature​(String forceMatchingSignature)
        Force matching signature Example: “18067345456756876713”
        Parameters:
        forceMatchingSignature - the value to set
        Returns:
        this builder

      • timeGenerated

        public SqlPlanLine.Builder timeGenerated​(Date timeGenerated)
        Generation time stamp Example: “2020-05-05T02:10:00.000Z”
        Parameters:
        timeGenerated - the value to set
        Returns:
        this builder

      • timeCollected

        public SqlPlanLine.Builder timeCollected​(Date timeCollected)
        Collection time stamp Example: “2020-05-06T00:00:00.000Z”
        Parameters:
        timeCollected - the value to set
        Returns:
        this builder

      • operation

        public SqlPlanLine.Builder operation​(String operation)
        Operation Example: “SELECT STATEMENT”
        Parameters:
        operation - the value to set
        Returns:
        this builder

      • remark

        public SqlPlanLine.Builder remark​(String remark)
        Remark Example: ""
        Parameters:
        remark - the value to set
        Returns:
        this builder

      • options

        public SqlPlanLine.Builder options​(String options)
        Options Example: “RANGE SCAN”
        Parameters:
        options - the value to set
        Returns:
        this builder

      • objectNode

        public SqlPlanLine.Builder objectNode​(String objectNode)
        Object Node Example: “Q4000”
        Parameters:
        objectNode - the value to set
        Returns:
        this builder

      • objectOwner

        public SqlPlanLine.Builder objectOwner​(String objectOwner)
        Object Owner Example: “TENANT_A#SCHEMA”
        Parameters:
        objectOwner - the value to set
        Returns:
        this builder

      • objectName

        public SqlPlanLine.Builder objectName​(String objectName)
        Object Name Example: “PLAN_LINES_PK”
        Parameters:
        objectName - the value to set
        Returns:
        this builder

      • objectAlias

        public SqlPlanLine.Builder objectAlias​(String objectAlias)
        Object Alias Example: “PLAN_LINES@SEL$1”
        Parameters:
        objectAlias - the value to set
        Returns:
        this builder

      • objectInstance

        public SqlPlanLine.Builder objectInstance​(Long objectInstance)
        Object Instance Example: 37472
        Parameters:
        objectInstance - the value to set
        Returns:
        this builder

      • objectType

        public SqlPlanLine.Builder objectType​(String objectType)
        Object Type Example: “INDEX (UNIQUE)”
        Parameters:
        objectType - the value to set
        Returns:
        this builder

      • optimizer

        public SqlPlanLine.Builder optimizer​(String optimizer)
        Optimizer Example: “CLUSTER”
        Parameters:
        optimizer - the value to set
        Returns:
        this builder

      • searchColumns

        public SqlPlanLine.Builder searchColumns​(Long searchColumns)
        Search Columns Example: 3
        Parameters:
        searchColumns - the value to set
        Returns:
        this builder

      • identifier

        public SqlPlanLine.Builder identifier​(Long identifier)
        Identifier Example: 3
        Parameters:
        identifier - the value to set
        Returns:
        this builder

      • parentIdentifier

        public SqlPlanLine.Builder parentIdentifier​(Long parentIdentifier)
        Parent Identifier Example: 2
        Parameters:
        parentIdentifier - the value to set
        Returns:
        this builder

      • depth

        public SqlPlanLine.Builder depth​(Long depth)
        Depth Example: 3
        Parameters:
        depth - the value to set
        Returns:
        this builder

      • position

        public SqlPlanLine.Builder position​(Long position)
        Position Example: 1
        Parameters:
        position - the value to set
        Returns:
        this builder

      • cost

        public SqlPlanLine.Builder cost​(Long cost)
        Cost Example: 1
        Parameters:
        cost - the value to set
        Returns:
        this builder

      • cardinality

        public SqlPlanLine.Builder cardinality​(Long cardinality)
        Cardinality Example: 1
        Parameters:
        cardinality - the value to set
        Returns:
        this builder

      • bytes

        public SqlPlanLine.Builder bytes​(Long bytes)
        Bytes Example: 150
        Parameters:
        bytes - the value to set
        Returns:
        this builder

      • other

        public SqlPlanLine.Builder other​(String other)
        Other Example:
        Parameters:
        other - the value to set
        Returns:
        this builder

      • otherTag

        public SqlPlanLine.Builder otherTag​(String otherTag)
        Other Tag Example: “PARALLEL_COMBINED_WITH_PARENT”
        Parameters:
        otherTag - the value to set
        Returns:
        this builder

      • partitionStart

        public SqlPlanLine.Builder partitionStart​(String partitionStart)
        Partition start Example: 1
        Parameters:
        partitionStart - the value to set
        Returns:
        this builder

      • partitionStop

        public SqlPlanLine.Builder partitionStop​(String partitionStop)
        Partition stop Example: 2
        Parameters:
        partitionStop - the value to set
        Returns:
        this builder

      • partitionIdentifier

        public SqlPlanLine.Builder partitionIdentifier​(Long partitionIdentifier)
        Partition identifier Example: 8
        Parameters:
        partitionIdentifier - the value to set
        Returns:
        this builder

      • distribution

        public SqlPlanLine.Builder distribution​(String distribution)
        Distribution Example: “QC (RANDOM)”
        Parameters:
        distribution - the value to set
        Returns:
        this builder

      • cpuCost

        public SqlPlanLine.Builder cpuCost​(Long cpuCost)
        CPU cost Example: 7321
        Parameters:
        cpuCost - the value to set
        Returns:
        this builder

      • ioCost

        public SqlPlanLine.Builder ioCost​(Long ioCost)
        IO cost Example: 1
        Parameters:
        ioCost - the value to set
        Returns:
        this builder

      • tempSpace

        public SqlPlanLine.Builder tempSpace​(Long tempSpace)
        Time space Example: 15614000
        Parameters:
        tempSpace - the value to set
        Returns:
        this builder

      • accessPredicates

        public SqlPlanLine.Builder accessPredicates​(String accessPredicates)
        Access predicates Example: “\“RESOURCE_ID\”=:1 AND \“QUERY_ID\”=:2”
        Parameters:
        accessPredicates - the value to set
        Returns:
        this builder

      • filterPredicates

        public SqlPlanLine.Builder filterPredicates​(String filterPredicates)
        Filter predicates Example: “(INTERNAL_FUNCTION(\“J\”.\“DATABASE_ROLE\”) OR (\“J\”.\“DATABASE_ROLE\” IS NULL AND SYS_CONTEXT(‘userenv’,‘database_role’)=‘PRIMARY’))”
        Parameters:
        filterPredicates - the value to set
        Returns:
        this builder

      • projection

        public SqlPlanLine.Builder projection​(String projection)
        Projection Example: “COUNT(*)[22]”
        Parameters:
        projection - the value to set
        Returns:
        this builder

      • qblockName

        public SqlPlanLine.Builder qblockName​(String qblockName)
        Qblock Name Example: “SEL$1”
        Parameters:
        qblockName - the value to set
        Returns:
        this builder

      • elapsedTimeInSec

        public SqlPlanLine.Builder elapsedTimeInSec​(Float elapsedTimeInSec)
        Total elapsed time Example: 1.2
        Parameters:
        elapsedTimeInSec - the value to set
        Returns:
        this builder

      • otherXML

        public SqlPlanLine.Builder otherXML​(String otherXML)
        Other SQL Example: “<other_xml><info type=\“db_version\”>18.0.0.0<info type=\“parse_schema\”><info type=\“plan_hash_full\”>483892784<info type=\“plan_hash\”>2709293936<info type=\“plan_hash_2\”>483892784<outline_data></outline_data></other_xml>”
        Parameters:
        otherXML - the value to set
        Returns:
        this builder