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