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.
`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.
`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.
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.

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

bytes¶

Gets the bytes of this SqlPlanLine. Bytes Example: 150

Returns:	The bytes of this SqlPlanLine.
Return type:	int

cardinality¶

Gets the cardinality of this SqlPlanLine. Cardinality Example: 1

Returns:	The cardinality of this SqlPlanLine.
Return type:	int

cost¶

Gets the cost of this SqlPlanLine. Cost Example: 1

Returns:	The cost of this SqlPlanLine.
Return type:	int

cpu_cost¶

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

Returns:	The cpu_cost of this SqlPlanLine.
Return type:	int

depth¶

Gets the depth of this SqlPlanLine. Depth Example: 3

Returns:	The depth of this SqlPlanLine.
Return type:	int

distribution¶

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

Returns:	The distribution of this SqlPlanLine.
Return type:	str

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

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

identifier¶

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

Returns:	The identifier of this SqlPlanLine.
Return type:	int

io_cost¶

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

Returns:	The io_cost of this SqlPlanLine.
Return type:	int

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

object_instance¶

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

Returns:	The object_instance of this SqlPlanLine.
Return type:	int

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

object_node¶

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

Returns:	The object_node of this SqlPlanLine.
Return type:	str

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

object_type¶

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

Returns:	The object_type of this SqlPlanLine.
Return type:	str

operation¶

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

Returns:	The operation of this SqlPlanLine.
Return type:	str

optimizer¶

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

Returns:	The optimizer of this SqlPlanLine.
Return type:	str

options¶

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

Returns:	The options of this SqlPlanLine.
Return type:	str

other¶

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

Returns:	The other of this SqlPlanLine.
Return type:	str

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

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

parent_identifier¶

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

Returns:	The parent_identifier of this SqlPlanLine.
Return type:	int

partition_identifier¶

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

Returns:	The partition_identifier of this SqlPlanLine.
Return type:	int

partition_start¶

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

Returns:	The partition_start of this SqlPlanLine.
Return type:	str

partition_stop¶

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

Returns:	The partition_stop of this SqlPlanLine.
Return type:	str

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

position¶

Gets the position of this SqlPlanLine. Position Example: 1

Returns:	The position of this SqlPlanLine.
Return type:	int

projection¶

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

Returns:	The projection of this SqlPlanLine.
Return type:	str

qblock_name¶

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

Returns:	The qblock_name of this SqlPlanLine.
Return type:	str

remark¶

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

Returns:	The remark of this SqlPlanLine.
Return type:	str

search_columns¶

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

Returns:	The search_columns of this SqlPlanLine.
Return type:	int

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

temp_space¶

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

Returns:	The temp_space of this SqlPlanLine.
Return type:	int

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

version¶

Gets the version of this SqlPlanLine. Version Example: 1

Returns:	The version of this SqlPlanLine.
Return type:	float