SqlPlanLine.Builder |
SqlPlanLine.Builder.accessPredicates(String accessPredicates) |
Access predicates Example: “\“RESOURCE_ID\”=:1 AND \“QUERY_ID\”=:2”
|
static SqlPlanLine.Builder |
SqlPlanLine.builder() |
Create a new builder.
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.bytes(Long bytes) |
Bytes Example: 150
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.cardinality(Long cardinality) |
Cardinality Example: 1
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.copy(SqlPlanLine model) |
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.cost(Long cost) |
Cost Example: 1
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.cpuCost(Long cpuCost) |
CPU cost Example: 7321
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.depth(Long depth) |
Depth Example: 3
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.distribution(String distribution) |
Distribution Example: “QC (RANDOM)”
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.elapsedTimeInSec(Float elapsedTimeInSec) |
Total elapsed time Example: 1.2
|
SqlPlanLine.Builder |
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 |
SqlPlanLine.Builder.forceMatchingSignature(String forceMatchingSignature) |
Force matching signature Example: “18067345456756876713”
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.identifier(Long identifier) |
Identifier Example: 3
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.ioCost(Long ioCost) |
IO cost Example: 1
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.objectAlias(String objectAlias) |
Object Alias Example: “PLAN_LINES@SEL$1”
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.objectInstance(Long objectInstance) |
Object Instance Example: 37472
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.objectName(String objectName) |
Object Name Example: “PLAN_LINES_PK”
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.objectNode(String objectNode) |
Object Node Example: “Q4000”
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.objectOwner(String objectOwner) |
Object Owner Example: “TENANT_A#SCHEMA”
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.objectType(String objectType) |
Object Type Example: “INDEX (UNIQUE)”
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.operation(String operation) |
Operation Example: “SELECT STATEMENT”
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.optimizer(String optimizer) |
Optimizer Example: “CLUSTER”
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.options(String options) |
Options Example: “RANGE SCAN”
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.other(String other) |
Other Example:
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.otherTag(String otherTag) |
Other Tag Example: “PARALLEL_COMBINED_WITH_PARENT”
|
SqlPlanLine.Builder |
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>”
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.parentIdentifier(Long parentIdentifier) |
Parent Identifier Example: 2
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.partitionIdentifier(Long partitionIdentifier) |
Partition identifier Example: 8
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.partitionStart(String partitionStart) |
Partition start Example: 1
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.partitionStop(String partitionStop) |
Partition stop Example: 2
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.planHash(Long planHash) |
Plan hash value for the SQL Execution Plan
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.position(Long position) |
Position Example: 1
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.projection(String projection) |
Projection Example: “COUNT(*)[22]”
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.qblockName(String qblockName) |
Qblock Name Example: “SEL$1”
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.remark(String remark) |
Remark Example: ""
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.searchColumns(Long searchColumns) |
Search Columns Example: 3
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.sqlIdentifier(String sqlIdentifier) |
Unique SQL_ID for a SQL Statement.
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.tempSpace(Long tempSpace) |
Time space Example: 15614000
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.timeCollected(Date timeCollected) |
Collection time stamp Example: “2020-05-06T00:00:00.000Z”
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.timeGenerated(Date timeGenerated) |
Generation time stamp Example: “2020-05-05T02:10:00.000Z”
|
SqlPlanLine.Builder |
SqlPlanLine.toBuilder() |
|
SqlPlanLine.Builder |
SqlPlanLine.Builder.version(Float version) |
Version Example: 1
|