SqlPlanLine

class oci.opsi.models.SqlPlanLine(**kwargs)

Bases: object

SQL Plan Line type object.

Methods:

__init__(**kwargs)

Initializes a new SqlPlanLine object with values from keyword arguments.

Attributes:

access_predicates

Gets the access_predicates of this SqlPlanLine.

bytes

Gets the bytes of this SqlPlanLine.

cardinality

Gets the cardinality of this SqlPlanLine.

cost

Gets the cost of this SqlPlanLine.

cpu_cost

Gets the cpu_cost of this SqlPlanLine.

depth

Gets the depth of this SqlPlanLine.

distribution

Gets the distribution of this SqlPlanLine.

elapsed_time_in_sec

Gets the elapsed_time_in_sec of this SqlPlanLine.

filter_predicates

Gets the filter_predicates of this SqlPlanLine.

force_matching_signature

Gets the force_matching_signature of this SqlPlanLine.

identifier

[Required] Gets the identifier of this SqlPlanLine.

io_cost

Gets the io_cost of this SqlPlanLine.

object_alias

Gets the object_alias of this SqlPlanLine.

object_instance

Gets the object_instance of this SqlPlanLine.

object_name

Gets the object_name of this SqlPlanLine.

object_node

Gets the object_node of this SqlPlanLine.

object_owner

Gets the object_owner of this SqlPlanLine.

object_type

Gets the object_type of this SqlPlanLine.

operation

[Required] Gets the operation of this SqlPlanLine.

optimizer

Gets the optimizer of this SqlPlanLine.

options

Gets the options of this SqlPlanLine.

other

Gets the other of this SqlPlanLine.

other_tag

Gets the other_tag of this SqlPlanLine.

other_xml

Gets the other_xml of this SqlPlanLine.

parent_identifier

Gets the parent_identifier of this SqlPlanLine.

partition_identifier

Gets the partition_identifier of this SqlPlanLine.

partition_start

Gets the partition_start of this SqlPlanLine.

partition_stop

Gets the partition_stop of this SqlPlanLine.

plan_hash

[Required] Gets the plan_hash of this SqlPlanLine.

position

Gets the position of this SqlPlanLine.

projection

Gets the projection of this SqlPlanLine.

qblock_name

Gets the qblock_name of this SqlPlanLine.

remark

Gets the remark of this SqlPlanLine.

search_columns

Gets the search_columns of this SqlPlanLine.

sql_identifier

[Required] Gets the sql_identifier of this SqlPlanLine.

temp_space

Gets the temp_space of this SqlPlanLine.

time_collected

[Required] Gets the time_collected of this SqlPlanLine.

time_generated

Gets the time_generated of this SqlPlanLine.

version

Gets the version of this SqlPlanLine.

__init__(**kwargs)

Initializes a new SqlPlanLine object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters
  • version (float) – The value to assign to the version property of this SqlPlanLine.

  • sql_identifier (str) – The value to assign to the sql_identifier property of this SqlPlanLine.

  • plan_hash (int) – The value to assign to the plan_hash property of this SqlPlanLine.

  • force_matching_signature (str) – The value to assign to the force_matching_signature property of this SqlPlanLine.

  • time_generated (datetime) – The value to assign to the time_generated property of this SqlPlanLine.

  • time_collected (datetime) – The value to assign to the time_collected property of this SqlPlanLine.

  • operation (str) – The value to assign to the operation property of this SqlPlanLine.

  • remark (str) – The value to assign to the remark property of this SqlPlanLine.

  • options (str) – The value to assign to the options property of this SqlPlanLine.

  • object_node (str) – The value to assign to the object_node property of this SqlPlanLine.

  • object_owner (str) – The value to assign to the object_owner property of this SqlPlanLine.

  • object_name (str) – The value to assign to the object_name property of this SqlPlanLine.

  • object_alias (str) – The value to assign to the object_alias property of this SqlPlanLine.

  • object_instance (int) – The value to assign to the object_instance property of this SqlPlanLine.

  • object_type (str) – The value to assign to the object_type property of this SqlPlanLine.

  • optimizer (str) – The value to assign to the optimizer property of this SqlPlanLine.

  • search_columns (int) – The value to assign to the search_columns property of this SqlPlanLine.

  • identifier (int) – The value to assign to the identifier property of this SqlPlanLine.

  • parent_identifier (int) – The value to assign to the parent_identifier property of this SqlPlanLine.

  • depth (int) – The value to assign to the depth property of this SqlPlanLine.

  • position (int) – The value to assign to the position property of this SqlPlanLine.

  • cost (int) – The value to assign to the cost property of this SqlPlanLine.

  • cardinality (int) – The value to assign to the cardinality property of this SqlPlanLine.

  • bytes (int) – The value to assign to the bytes property of this SqlPlanLine.

  • other (str) – The value to assign to the other property of this SqlPlanLine.

  • other_tag (str) – The value to assign to the other_tag property of this SqlPlanLine.

  • partition_start (str) – The value to assign to the partition_start property of this SqlPlanLine.

  • partition_stop (str) – The value to assign to the partition_stop property of this SqlPlanLine.

  • partition_identifier (int) – The value to assign to the partition_identifier property of this SqlPlanLine.

  • distribution (str) – The value to assign to the distribution property of this SqlPlanLine.

  • cpu_cost (int) – The value to assign to the cpu_cost property of this SqlPlanLine.

  • io_cost (int) – The value to assign to the io_cost property of this SqlPlanLine.

  • temp_space (int) – The value to assign to the temp_space property of this SqlPlanLine.

  • access_predicates (str) – The value to assign to the access_predicates property of this SqlPlanLine.

  • filter_predicates (str) – The value to assign to the filter_predicates property of this SqlPlanLine.

  • projection (str) – The value to assign to the projection property of this SqlPlanLine.

  • qblock_name (str) – The value to assign to the qblock_name property of this SqlPlanLine.

  • elapsed_time_in_sec (float) – The value to assign to the elapsed_time_in_sec property of this SqlPlanLine.

  • other_xml (str) – The value to assign to the other_xml property of this SqlPlanLine.

property access_predicates

Gets the access_predicates of this SqlPlanLine. Access predicates Example: “”RESOURCE_ID”=:1 AND “QUERY_ID”=:2”

Returns

The access_predicates of this SqlPlanLine.

Return type

str

property bytes

Gets the bytes of this SqlPlanLine. Bytes Example: 150

Returns

The bytes of this SqlPlanLine.

Return type

int

property cardinality

Gets the cardinality of this SqlPlanLine. Cardinality Example: 1

Returns

The cardinality of this SqlPlanLine.

Return type

int

property cost

Gets the cost of this SqlPlanLine. Cost Example: 1

Returns

The cost of this SqlPlanLine.

Return type

int

property cpu_cost

Gets the cpu_cost of this SqlPlanLine. CPU cost Example: 7321

Returns

The cpu_cost of this SqlPlanLine.

Return type

int

property depth

Gets the depth of this SqlPlanLine. Depth Example: 3

Returns

The depth of this SqlPlanLine.

Return type

int

property distribution

Gets the distribution of this SqlPlanLine. Distribution Example: “QC (RANDOM)”

Returns

The distribution of this SqlPlanLine.

Return type

str

property elapsed_time_in_sec

Gets the elapsed_time_in_sec of this SqlPlanLine. Total elapsed time Example: 1.2

Returns

The elapsed_time_in_sec of this SqlPlanLine.

Return type

float

property filter_predicates

Gets the filter_predicates of this SqlPlanLine. Filter predicates Example: “(INTERNAL_FUNCTION(“J”.”DATABASE_ROLE”) OR (“J”.”DATABASE_ROLE” IS NULL AND SYS_CONTEXT(‘userenv’,’database_role’)=’PRIMARY’))”

Returns

The filter_predicates of this SqlPlanLine.

Return type

str

property force_matching_signature

Gets the force_matching_signature of this SqlPlanLine. Force matching signature Example: “18067345456756876713”

Returns

The force_matching_signature of this SqlPlanLine.

Return type

str

property identifier

[Required] Gets the identifier of this SqlPlanLine. Identifier Example: 3

Returns

The identifier of this SqlPlanLine.

Return type

int

property io_cost

Gets the io_cost of this SqlPlanLine. IO cost Example: 1

Returns

The io_cost of this SqlPlanLine.

Return type

int

property object_alias

Gets the object_alias of this SqlPlanLine. Object Alias Example: “PLAN_LINES@SEL$1”

Returns

The object_alias of this SqlPlanLine.

Return type

str

property object_instance

Gets the object_instance of this SqlPlanLine. Object Instance Example: 37472

Returns

The object_instance of this SqlPlanLine.

Return type

int

property object_name

Gets the object_name of this SqlPlanLine. Object Name Example: “PLAN_LINES_PK”

Returns

The object_name of this SqlPlanLine.

Return type

str

property object_node

Gets the object_node of this SqlPlanLine. Object Node Example: “Q4000”

Returns

The object_node of this SqlPlanLine.

Return type

str

property object_owner

Gets the object_owner of this SqlPlanLine. Object Owner Example: “TENANT_A#SCHEMA”

Returns

The object_owner of this SqlPlanLine.

Return type

str

property object_type

Gets the object_type of this SqlPlanLine. Object Type Example: “INDEX (UNIQUE)”

Returns

The object_type of this SqlPlanLine.

Return type

str

property operation

[Required] Gets the operation of this SqlPlanLine. Operation Example: “SELECT STATEMENT”

Returns

The operation of this SqlPlanLine.

Return type

str

property optimizer

Gets the optimizer of this SqlPlanLine. Optimizer Example: “CLUSTER”

Returns

The optimizer of this SqlPlanLine.

Return type

str

property options

Gets the options of this SqlPlanLine. Options Example: “RANGE SCAN”

Returns

The options of this SqlPlanLine.

Return type

str

property other

Gets the other of this SqlPlanLine. Other Example: ``

Returns

The other of this SqlPlanLine.

Return type

str

property other_tag

Gets the other_tag of this SqlPlanLine. Other Tag Example: “PARALLEL_COMBINED_WITH_PARENT”

Returns

The other_tag of this SqlPlanLine.

Return type

str

property other_xml

Gets the other_xml of this SqlPlanLine. 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>”

Returns

The other_xml of this SqlPlanLine.

Return type

str

property parent_identifier

Gets the parent_identifier of this SqlPlanLine. Parent Identifier Example: 2

Returns

The parent_identifier of this SqlPlanLine.

Return type

int

property partition_identifier

Gets the partition_identifier of this SqlPlanLine. Partition identifier Example: 8

Returns

The partition_identifier of this SqlPlanLine.

Return type

int

property partition_start

Gets the partition_start of this SqlPlanLine. Partition start Example: 1

Returns

The partition_start of this SqlPlanLine.

Return type

str

property partition_stop

Gets the partition_stop of this SqlPlanLine. Partition stop Example: 2

Returns

The partition_stop of this SqlPlanLine.

Return type

str

property plan_hash

[Required] Gets the plan_hash of this SqlPlanLine. Plan hash value for the SQL Execution Plan

Returns

The plan_hash of this SqlPlanLine.

Return type

int

property position

Gets the position of this SqlPlanLine. Position Example: 1

Returns

The position of this SqlPlanLine.

Return type

int

property projection

Gets the projection of this SqlPlanLine. Projection Example: “COUNT(*)[22]”

Returns

The projection of this SqlPlanLine.

Return type

str

property qblock_name

Gets the qblock_name of this SqlPlanLine. Qblock Name Example: “SEL$1”

Returns

The qblock_name of this SqlPlanLine.

Return type

str

property remark

Gets the remark of this SqlPlanLine. Remark Example: “”

Returns

The remark of this SqlPlanLine.

Return type

str

property search_columns

Gets the search_columns of this SqlPlanLine. Search Columns Example: 3

Returns

The search_columns of this SqlPlanLine.

Return type

int

property sql_identifier

[Required] Gets the sql_identifier of this SqlPlanLine. Unique SQL_ID for a SQL Statement.

Returns

The sql_identifier of this SqlPlanLine.

Return type

str

property temp_space

Gets the temp_space of this SqlPlanLine. Time space Example: 15614000

Returns

The temp_space of this SqlPlanLine.

Return type

int

property time_collected

[Required] Gets the time_collected of this SqlPlanLine. Collection time stamp Example: “2020-05-06T00:00:00.000Z”

Returns

The time_collected of this SqlPlanLine.

Return type

datetime

property time_generated

Gets the time_generated of this SqlPlanLine. Generation time stamp Example: “2020-05-05T02:10:00.000Z”

Returns

The time_generated of this SqlPlanLine.

Return type

datetime

property version

Gets the version of this SqlPlanLine. Version Example: 1

Returns

The version of this SqlPlanLine.

Return type

float