java.lang.Object
- com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
- - com.oracle.bmc.opsi.model.SqlPlanLine

```
@Generated(value="OracleSDKGenerator",
           comments="API Version: 20200630")
public final class SqlPlanLine
extends com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
```
SQL Plan Line type object.
Note: Objects should always be created or deserialized using the SqlPlanLine.Builder. This model distinguishes fields that are null because they are unset from fields that are explicitly set to null. This is done in the setter methods of the SqlPlanLine.Builder, which maintain a set of all explicitly set fields called SqlPlanLine.Builder.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take the explicitly set fields into account. The constructor, on the other hand, does not take the explicitly set fields into account (since the constructor cannot distinguish explicit null from unset null).

Nested Class Summary

Nested Classes
Modifier and Type Class Description

static class SqlPlanLine.Builder

Field Summary
- Fields inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
  EXPLICITLY_SET_FILTER_NAME, EXPLICITLY_SET_PROPERTY_NAME

Constructor Summary

Constructors
Constructor	Description
SqlPlanLine(Float version, String sqlIdentifier, Long planHash, String forceMatchingSignature, Date timeGenerated, Date timeCollected, String operation, String remark, String options, String objectNode, String objectOwner, String objectName, String objectAlias, Long objectInstance, String objectType, String optimizer, Long searchColumns, Long identifier, Long parentIdentifier, Long depth, Long position, Long cost, Long cardinality, Long bytes, String other, String otherTag, String partitionStart, String partitionStop, Long partitionIdentifier, String distribution, Long cpuCost, Long ioCost, Long tempSpace, String accessPredicates, String filterPredicates, String projection, String qblockName, Float elapsedTimeInSec, String otherXML)	Deprecated.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`static SqlPlanLine.Builder`	`builder()`	Create a new builder.
`boolean`	`equals(Object o)`
`String`	`getAccessPredicates()`	Access predicates Example: “\“RESOURCE_ID\”=:1 AND \“QUERY_ID\”=:2”
`Long`	`getBytes()`	Bytes Example: 150
`Long`	`getCardinality()`	Cardinality Example: 1
`Long`	`getCost()`	Cost Example: 1
`Long`	`getCpuCost()`	CPU cost Example: 7321
`Long`	`getDepth()`	Depth Example: 3
`String`	`getDistribution()`	Distribution Example: “QC (RANDOM)”
`Float`	`getElapsedTimeInSec()`	Total elapsed time Example: 1.2
`String`	`getFilterPredicates()`	Filter predicates Example: “(INTERNAL_FUNCTION(\“J\”.\“DATABASE_ROLE\”) OR (\“J\”.\“DATABASE_ROLE\” IS NULL AND SYS_CONTEXT(‘userenv’,‘database_role’)=‘PRIMARY’))”
`String`	`getForceMatchingSignature()`	Force matching signature Example: “18067345456756876713”
`Long`	`getIdentifier()`	Identifier Example: 3
`Long`	`getIoCost()`	IO cost Example: 1
`String`	`getObjectAlias()`	Object Alias Example: “PLAN_LINES@SEL$1”
`Long`	`getObjectInstance()`	Object Instance Example: 37472
`String`	`getObjectName()`	Object Name Example: “PLAN_LINES_PK”
`String`	`getObjectNode()`	Object Node Example: “Q4000”
`String`	`getObjectOwner()`	Object Owner Example: “TENANT_A#SCHEMA”
`String`	`getObjectType()`	Object Type Example: “INDEX (UNIQUE)”
`String`	`getOperation()`	Operation Example: “SELECT STATEMENT”
`String`	`getOptimizer()`	Optimizer Example: “CLUSTER”
`String`	`getOptions()`	Options Example: “RANGE SCAN”
`String`	`getOther()`	Other Example:
`String`	`getOtherTag()`	Other Tag Example: “PARALLEL_COMBINED_WITH_PARENT”
`String`	`getOtherXML()`	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>”
`Long`	`getParentIdentifier()`	Parent Identifier Example: 2
`Long`	`getPartitionIdentifier()`	Partition identifier Example: 8
`String`	`getPartitionStart()`	Partition start Example: 1
`String`	`getPartitionStop()`	Partition stop Example: 2
`Long`	`getPlanHash()`	Plan hash value for the SQL Execution Plan
`Long`	`getPosition()`	Position Example: 1
`String`	`getProjection()`	Projection Example: “COUNT(*)[22]”
`String`	`getQblockName()`	Qblock Name Example: “SEL$1”
`String`	`getRemark()`	Remark Example: ""
`Long`	`getSearchColumns()`	Search Columns Example: 3
`String`	`getSqlIdentifier()`	Unique SQL_ID for a SQL Statement.
`Long`	`getTempSpace()`	Time space Example: 15614000
`Date`	`getTimeCollected()`	Collection time stamp Example: “2020-05-06T00:00:00.000Z”
`Date`	`getTimeGenerated()`	Generation time stamp Example: “2020-05-05T02:10:00.000Z”
`Float`	`getVersion()`	Version Example: 1
`int`	`hashCode()`
`SqlPlanLine.Builder`	`toBuilder()`
`String`	`toString()`
`String`	`toString(boolean includeByteArrayContents)`	Return a string representation of the object.

Methods inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
markPropertyAsExplicitlySet, wasPropertyExplicitlySet

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

Constructor Detail

SqlPlanLine

@Deprecated
@ConstructorProperties({"version","sqlIdentifier","planHash","forceMatchingSignature","timeGenerated","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"})
public SqlPlanLine(Float version,
                   String sqlIdentifier,
                   Long planHash,
                   String forceMatchingSignature,
                   Date timeGenerated,
                   Date timeCollected,
                   String operation,
                   String remark,
                   String options,
                   String objectNode,
                   String objectOwner,
                   String objectName,
                   String objectAlias,
                   Long objectInstance,
                   String objectType,
                   String optimizer,
                   Long searchColumns,
                   Long identifier,
                   Long parentIdentifier,
                   Long depth,
                   Long position,
                   Long cost,
                   Long cardinality,
                   Long bytes,
                   String other,
                   String otherTag,
                   String partitionStart,
                   String partitionStop,
                   Long partitionIdentifier,
                   String distribution,
                   Long cpuCost,
                   Long ioCost,
                   Long tempSpace,
                   String accessPredicates,
                   String filterPredicates,
                   String projection,
                   String qblockName,
                   Float elapsedTimeInSec,
                   String otherXML)

Deprecated.

Method Detail
- builder
```
public static SqlPlanLine.Builder builder()
```
  Create a new builder.
- toBuilder
```
public SqlPlanLine.Builder toBuilder()
```
- getVersion
```
public Float getVersion()
```
  Version Example: 1
  
  Returns:
  
  the value
- getSqlIdentifier
```
public String getSqlIdentifier()
```
  Unique SQL_ID for a SQL Statement.
  
  Returns:
  
  the value
- getPlanHash
```
public Long getPlanHash()
```
  Plan hash value for the SQL Execution Plan
  
  Returns:
  
  the value
- getForceMatchingSignature
```
public String getForceMatchingSignature()
```
  Force matching signature Example: “18067345456756876713”
  
  Returns:
  
  the value
- getTimeGenerated
```
public Date getTimeGenerated()
```
  Generation time stamp Example: “2020-05-05T02:10:00.000Z”
  
  Returns:
  
  the value
- getTimeCollected
```
public Date getTimeCollected()
```
  Collection time stamp Example: “2020-05-06T00:00:00.000Z”
  
  Returns:
  
  the value
- getOperation
```
public String getOperation()
```
  Operation Example: “SELECT STATEMENT”
  
  Returns:
  
  the value
- getRemark
```
public String getRemark()
```
  Remark Example: ""
  
  Returns:
  
  the value
- getOptions
```
public String getOptions()
```
  Options Example: “RANGE SCAN”
  
  Returns:
  
  the value
- getObjectNode
```
public String getObjectNode()
```
  Object Node Example: “Q4000”
  
  Returns:
  
  the value
- getObjectOwner
```
public String getObjectOwner()
```
  Object Owner Example: “TENANT_A#SCHEMA”
  
  Returns:
  
  the value
- getObjectName
```
public String getObjectName()
```
  Object Name Example: “PLAN_LINES_PK”
  
  Returns:
  
  the value
- getObjectAlias
```
public String getObjectAlias()
```
  Object Alias Example: “PLAN_LINES@SEL$1”
  
  Returns:
  
  the value
- getObjectInstance
```
public Long getObjectInstance()
```
  Object Instance Example: 37472
  
  Returns:
  
  the value
- getObjectType
```
public String getObjectType()
```
  Object Type Example: “INDEX (UNIQUE)”
  
  Returns:
  
  the value
- getOptimizer
```
public String getOptimizer()
```
  Optimizer Example: “CLUSTER”
  
  Returns:
  
  the value
- getSearchColumns
```
public Long getSearchColumns()
```
  Search Columns Example: 3
  
  Returns:
  
  the value
- getIdentifier
```
public Long getIdentifier()
```
  Identifier Example: 3
  
  Returns:
  
  the value
- getParentIdentifier
```
public Long getParentIdentifier()
```
  Parent Identifier Example: 2
  
  Returns:
  
  the value
- getDepth
```
public Long getDepth()
```
  Depth Example: 3
  
  Returns:
  
  the value
- getPosition
```
public Long getPosition()
```
  Position Example: 1
  
  Returns:
  
  the value
- getCost
```
public Long getCost()
```
  Cost Example: 1
  
  Returns:
  
  the value
- getCardinality
```
public Long getCardinality()
```
  Cardinality Example: 1
  
  Returns:
  
  the value
- getBytes
```
public Long getBytes()
```
  Bytes Example: 150
  
  Returns:
  
  the value
- getOther
```
public String getOther()
```
  Other Example:
  
  Returns:
  
  the value
- getOtherTag
```
public String getOtherTag()
```
  Other Tag Example: “PARALLEL_COMBINED_WITH_PARENT”
  
  Returns:
  
  the value
- getPartitionStart
```
public String getPartitionStart()
```
  Partition start Example: 1
  
  Returns:
  
  the value
- getPartitionStop
```
public String getPartitionStop()
```
  Partition stop Example: 2
  
  Returns:
  
  the value
- getPartitionIdentifier
```
public Long getPartitionIdentifier()
```
  Partition identifier Example: 8
  
  Returns:
  
  the value
- getDistribution
```
public String getDistribution()
```
  Distribution Example: “QC (RANDOM)”
  
  Returns:
  
  the value
- getCpuCost
```
public Long getCpuCost()
```
  CPU cost Example: 7321
  
  Returns:
  
  the value
- getIoCost
```
public Long getIoCost()
```
  IO cost Example: 1
  
  Returns:
  
  the value
- getTempSpace
```
public Long getTempSpace()
```
  Time space Example: 15614000
  
  Returns:
  
  the value
- getAccessPredicates
```
public String getAccessPredicates()
```
  Access predicates Example: “\“RESOURCE_ID\”=:1 AND \“QUERY_ID\”=:2”
  
  Returns:
  
  the value
- getFilterPredicates
```
public String getFilterPredicates()
```
  Filter predicates Example: “(INTERNAL_FUNCTION(\“J\”.\“DATABASE_ROLE\”) OR (\“J\”.\“DATABASE_ROLE\” IS NULL AND SYS_CONTEXT(‘userenv’,‘database_role’)=‘PRIMARY’))”
  
  Returns:
  
  the value
- getProjection
```
public String getProjection()
```
  Projection Example: “COUNT(*)[22]”
  
  Returns:
  
  the value
- getQblockName
```
public String getQblockName()
```
  Qblock Name Example: “SEL$1”
  
  Returns:
  
  the value
- getElapsedTimeInSec
```
public Float getElapsedTimeInSec()
```
  Total elapsed time Example: 1.2
  
  Returns:
  
  the value
- getOtherXML
```
public String getOtherXML()
```
  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>”
  
  Returns:
  
  the value
- toString
```
public String toString()
```
  Overrides:
  
  toString in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
- toString
```
public String toString(boolean includeByteArrayContents)
```
  Return a string representation of the object.
  
  Parameters:
  
  includeByteArrayContents - true to include the full contents of byte arrays
  
  Returns:
  
  string representation
- equals
```
public boolean equals(Object o)
```
  Overrides:
  
  equals in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
- hashCode
```
public int hashCode()
```
  Overrides:
  
  hashCode in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

Class SqlPlanLine

Nested Class Summary

Field Summary

Fields inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

Constructor Summary

Method Summary

Methods inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

Methods inherited from class java.lang.Object

Constructor Detail

SqlPlanLine

Method Detail

builder

toBuilder

getVersion

getSqlIdentifier

getPlanHash

getForceMatchingSignature

getTimeGenerated

getTimeCollected

getOperation

getRemark

getOptions

getObjectNode

getObjectOwner

getObjectName

getObjectAlias

getObjectInstance

getObjectType

getOptimizer

getSearchColumns

getIdentifier

getParentIdentifier

getDepth

getPosition

getCost

getCardinality

getBytes

getOther

getOtherTag

getPartitionStart

getPartitionStop

getPartitionIdentifier

getDistribution

getCpuCost

getIoCost

getTempSpace

getAccessPredicates

getFilterPredicates

getProjection

getQblockName

getElapsedTimeInSec

getOtherXML

toString

toString

equals

hashCode