SqlPlanLine¶
- class oci.opsi.models.SqlPlanLine(**kwargs)¶
Bases:
objectSQL Plan Line type object.
Methods:
__init__(**kwargs)Initializes a new SqlPlanLine object with values from keyword arguments.
Attributes:
Gets the access_predicates of this SqlPlanLine.
Gets the bytes of this SqlPlanLine.
Gets the cardinality of this SqlPlanLine.
Gets the cost of this SqlPlanLine.
Gets the cpu_cost of this SqlPlanLine.
Gets the depth of this SqlPlanLine.
Gets the distribution of this SqlPlanLine.
Gets the elapsed_time_in_sec of this SqlPlanLine.
Gets the filter_predicates of this SqlPlanLine.
Gets the force_matching_signature of this SqlPlanLine.
[Required] Gets the identifier of this SqlPlanLine.
Gets the io_cost of this SqlPlanLine.
Gets the object_alias of this SqlPlanLine.
Gets the object_instance of this SqlPlanLine.
Gets the object_name of this SqlPlanLine.
Gets the object_node of this SqlPlanLine.
Gets the object_owner of this SqlPlanLine.
Gets the object_type of this SqlPlanLine.
[Required] Gets the operation of this SqlPlanLine.
Gets the optimizer of this SqlPlanLine.
Gets the options of this SqlPlanLine.
Gets the other of this SqlPlanLine.
Gets the other_tag of this SqlPlanLine.
Gets the other_xml of this SqlPlanLine.
Gets the parent_identifier of this SqlPlanLine.
Gets the partition_identifier of this SqlPlanLine.
Gets the partition_start of this SqlPlanLine.
Gets the partition_stop of this SqlPlanLine.
[Required] Gets the plan_hash of this SqlPlanLine.
Gets the position of this SqlPlanLine.
Gets the projection of this SqlPlanLine.
Gets the qblock_name of this SqlPlanLine.
Gets the remark of this SqlPlanLine.
Gets the search_columns of this SqlPlanLine.
[Required] Gets the sql_identifier of this SqlPlanLine.
Gets the temp_space of this SqlPlanLine.
[Required] Gets the time_collected of this SqlPlanLine.
Gets the time_generated of this SqlPlanLine.
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