Uses of Class
com.oracle.bmc.opsi.model.SqlPlanLine.Builder

Packages that use SqlPlanLine.Builder

Package	Description
com.oracle.bmc.opsi.model

Uses of SqlPlanLine.Builder in com.oracle.bmc.opsi.model

Methods in com.oracle.bmc.opsi.model that return SqlPlanLine.Builder

Modifier and Type	Method and Description
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.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><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	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.toBuilder()
SqlPlanLine.Builder	SqlPlanLine.Builder.version(Float version) Version Example: 1