@Generated(value="OracleSDKGenerator", comments="API Version: 20200630") public final class SqlPlanLine extends 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
ExplicitlySetBmcModel.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take
ExplicitlySetBmcModel.__explicitlySet__ into account. The constructor, on the other hand, does not set ExplicitlySetBmcModel.__explicitlySet__
(since the constructor cannot distinguish explicit null from unset null).
| Modifier and Type | Class and Description |
|---|---|
static class |
SqlPlanLine.Builder |
| 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 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 ExplicitlySetBmcModelpublic int hashCode()
hashCode in class ExplicitlySetBmcModelCopyright © 2016–2023. All rights reserved.