SqlPlanLine.Builder (Oracle Cloud Infrastructure Java SDK

java.lang.Object
- com.oracle.bmc.opsi.model.SqlPlanLine.Builder

Enclosing class:: SqlPlanLine

public static class SqlPlanLine.Builder
extends Object

Constructor Summary

Constructors
Constructor and Description

Builder()

Constructors
Constructor and Description
`Builder()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`SqlPlanLine.Builder`	`accessPredicates(String accessPredicates)` Access predicates Example: `"\\"RESOURCE_ID\\"=:1 AND \\"QUERY_ID\\"=:2"`
`SqlPlanLine`	`build()`
`SqlPlanLine.Builder`	`bytes(Long bytes)` Bytes Example: `150`
`SqlPlanLine.Builder`	`cardinality(Long cardinality)` Cardinality Example: `1`
`SqlPlanLine.Builder`	`copy(SqlPlanLine model)`
`SqlPlanLine.Builder`	`cost(Long cost)` Cost Example: `1`
`SqlPlanLine.Builder`	`cpuCost(Long cpuCost)` CPU cost Example: `7321`
`SqlPlanLine.Builder`	`depth(Long depth)` Depth Example: `3`
`SqlPlanLine.Builder`	`distribution(String distribution)` Distribution Example: `"QC (RANDOM)"`
`SqlPlanLine.Builder`	`elapsedTimeInSec(Float elapsedTimeInSec)` Total elapsed time Example: `1.2`
`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'))"`
`SqlPlanLine.Builder`	`identifier(Long identifier)` Identifier Example: `3`
`SqlPlanLine.Builder`	`ioCost(Long ioCost)` IO cost Example: `1`
`SqlPlanLine.Builder`	`objectAlias(String objectAlias)` Object Alias Example: `"PLAN_LINES@SEL$1"`
`SqlPlanLine.Builder`	`objectInstance(Long objectInstance)` Object Instance Example: `37472`
`SqlPlanLine.Builder`	`objectName(String objectName)` Object Name Example: `"PLAN_LINES_PK"`
`SqlPlanLine.Builder`	`objectNode(String objectNode)` Object Node Example: `"Q4000"`
`SqlPlanLine.Builder`	`objectOwner(String objectOwner)` Object Owner Example: `"TENANT_A#SCHEMA"`
`SqlPlanLine.Builder`	`objectType(String objectType)` Object Type Example: `"INDEX (UNIQUE)"`
`SqlPlanLine.Builder`	`operation(String operation)` Operation Example: `"SELECT STATEMENT"`
`SqlPlanLine.Builder`	`optimizer(String optimizer)` Optimizer Example: `"CLUSTER"`
`SqlPlanLine.Builder`	`options(String options)` Options Example: `"RANGE SCAN"`
`SqlPlanLine.Builder`	`other(String other)` Other Example:
`SqlPlanLine.Builder`	`otherTag(String otherTag)` Other Tag Example: `"PARALLEL_COMBINED_WITH_PARENT"`
`SqlPlanLine.Builder`	`otherXML(String otherXML)` Other SQL Example: "<other_xml><info type=\\"db_version\\">18.0.0.0</info><info type=\\"parse_schema\\"><![CDATA[\\"SYS\\"]]></info><info type=\\"plan_hash_full\\">483892784</info><info type=\\"plan_hash\\">2709293936</info><info type=\\"plan_hash_2\\">483892784</info><outline_data><hint><![CDATA[IGNORE_OPTIM_EMBEDDED_HINTS]]></hint><hint><![CDATA[OPTIMIZER_FEATURES_ENABLE('18.1.0')]]></hint><hint><![CDATA[DB_VERSION('18.1.0')]]></hint><hint><![CDATA[OPT_PARAM('_b_tree_bitmap_plans' 'false')]]></hint><hint><![CDATA[OPT_PARAM('_optim_peek_user_binds' 'false')]]></hint><hint><![CDATA[OPT_PARAM('result_cache_mode' 'FORCE')]]></hint><hint><![CDATA[OPT_PARAM('_fix_control' '20648883:0 27745220:1 30001331:1 30142527:1 30539126:1')]]></hint><hint><![CDATA[OUTLINE_LEAF(@\\"SEL$1\\")]]></hint><hint><![CDATA[INDEX(@\\"SEL$1\\" \\"USER$\\"@\\"SEL$1\\" \\"I_USER#\\")]]></hint></outline_data></other_xml>"
`SqlPlanLine.Builder`	`parentIdentifier(Long parentIdentifier)` Parent Identifier Example: `2`
`SqlPlanLine.Builder`	`partitionIdentifier(Long partitionIdentifier)` Partition identifier Example: `8`
`SqlPlanLine.Builder`	`partitionStart(String partitionStart)` Partition start Example: `1`
`SqlPlanLine.Builder`	`partitionStop(String partitionStop)` Partition stop Example: `2`
`SqlPlanLine.Builder`	`planHash(Long planHash)` Plan hash value for the SQL Execution Plan
`SqlPlanLine.Builder`	`position(Long position)` Position Example: `1`
`SqlPlanLine.Builder`	`projection(String projection)` Projection Example: `"COUNT(*)[22]"`
`SqlPlanLine.Builder`	`qblockName(String qblockName)` Qblock Name Example: `"SEL$1"`
`SqlPlanLine.Builder`	`remark(String remark)` Remark Example: `""`
`SqlPlanLine.Builder`	`searchColumns(Long searchColumns)` Search Columns Example: `3`
`SqlPlanLine.Builder`	`sqlIdentifier(String sqlIdentifier)` Unique SQL_ID for a SQL Statement.
`SqlPlanLine.Builder`	`tempSpace(Long tempSpace)` Time space Example: `15614000`
`SqlPlanLine.Builder`	`timeCollected(Date timeCollected)` Collection time stamp Example: `"2020-05-06T00:00:00.000Z"`
`SqlPlanLine.Builder`	`version(Float version)` Version Example: `1`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- 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
  - 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><info type=\\"parse_schema\\"><![CDATA[\\"SYS\\"]]></info><info type=\\"plan_hash_full\\">483892784</info><info type=\\"plan_hash\\">2709293936</info><info type=\\"plan_hash_2\\">483892784</info><outline_data><hint><![CDATA[IGNORE_OPTIM_EMBEDDED_HINTS]]></hint><hint><![CDATA[OPTIMIZER_FEATURES_ENABLE('18.1.0')]]></hint><hint><![CDATA[DB_VERSION('18.1.0')]]></hint><hint><![CDATA[OPT_PARAM('_b_tree_bitmap_plans' 'false')]]></hint><hint><![CDATA[OPT_PARAM('_optim_peek_user_binds' 'false')]]></hint><hint><![CDATA[OPT_PARAM('result_cache_mode' 'FORCE')]]></hint><hint><![CDATA[OPT_PARAM('_fix_control' '20648883:0 27745220:1 30001331:1 30142527:1 30539126:1')]]></hint><hint><![CDATA[OUTLINE_LEAF(@\\"SEL$1\\")]]></hint><hint><![CDATA[INDEX(@\\"SEL$1\\" \\"USER$\\"@\\"SEL$1\\" \\"I_USER#\\")]]></hint></outline_data></other_xml>"
    
    Parameters:
    
    otherXML - the value to set
    
    Returns:
    
    this builder
  - build
```
public SqlPlanLine build()
```
  - copy
```
public SqlPlanLine.Builder copy(SqlPlanLine model)
```

Class SqlPlanLine.Builder

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

Builder

Method Detail

version

sqlIdentifier

planHash

timeCollected

operation

remark

options

objectNode

objectOwner

objectName

objectAlias

objectInstance

objectType

optimizer

searchColumns

identifier

parentIdentifier

depth

position

cost

cardinality

bytes

other

otherTag

partitionStart

partitionStop

partitionIdentifier

distribution

cpuCost

ioCost

tempSpace

accessPredicates

filterPredicates

projection

qblockName

elapsedTimeInSec

otherXML

build

copy