SqlTuningTaskSqlExecutionPlanStep¶

class oci.database_management.models.SqlTuningTaskSqlExecutionPlanStep(**kwargs)¶

Bases: object

A step in the SQL execution plan.

Methods

__init__(**kwargs) Initializes a new SqlTuningTaskSqlExecutionPlanStep object with values from keyword arguments.

Attributes

`access_predicates`	Gets the access_predicates of this SqlTuningTaskSqlExecutionPlanStep.
`attribute`	Gets the attribute of this SqlTuningTaskSqlExecutionPlanStep.
`bytes`	Gets the bytes of this SqlTuningTaskSqlExecutionPlanStep.
`cardinality`	Gets the cardinality of this SqlTuningTaskSqlExecutionPlanStep.
`cost`	Gets the cost of this SqlTuningTaskSqlExecutionPlanStep.
`cpu_cost`	Gets the cpu_cost of this SqlTuningTaskSqlExecutionPlanStep.
`filter_predicates`	Gets the filter_predicates of this SqlTuningTaskSqlExecutionPlanStep.
`io_cost`	Gets the io_cost of this SqlTuningTaskSqlExecutionPlanStep.
`number_of_search_column`	Gets the number_of_search_column of this SqlTuningTaskSqlExecutionPlanStep.
`object_name`	Gets the object_name of this SqlTuningTaskSqlExecutionPlanStep.
`object_node`	Gets the object_node of this SqlTuningTaskSqlExecutionPlanStep.
`object_owner`	Gets the object_owner of this SqlTuningTaskSqlExecutionPlanStep.
`object_position`	Gets the object_position of this SqlTuningTaskSqlExecutionPlanStep.
`object_type`	Gets the object_type of this SqlTuningTaskSqlExecutionPlanStep.
`operation`	Gets the operation of this SqlTuningTaskSqlExecutionPlanStep.
`optimizer_mode`	Gets the optimizer_mode of this SqlTuningTaskSqlExecutionPlanStep.
`options`	Gets the options of this SqlTuningTaskSqlExecutionPlanStep.
`other`	Gets the other of this SqlTuningTaskSqlExecutionPlanStep.
`other_tag`	Gets the other_tag of this SqlTuningTaskSqlExecutionPlanStep.
`parent_step_id`	Gets the parent_step_id of this SqlTuningTaskSqlExecutionPlanStep.
`partition_id`	Gets the partition_id of this SqlTuningTaskSqlExecutionPlanStep.
`partition_start`	Gets the partition_start of this SqlTuningTaskSqlExecutionPlanStep.
`partition_stop`	Gets the partition_stop of this SqlTuningTaskSqlExecutionPlanStep.
`plan_hash_value`	Gets the plan_hash_value of this SqlTuningTaskSqlExecutionPlanStep.
`position`	Gets the position of this SqlTuningTaskSqlExecutionPlanStep.
`remarks`	Gets the remarks of this SqlTuningTaskSqlExecutionPlanStep.
`step_id`	Gets the step_id of this SqlTuningTaskSqlExecutionPlanStep.
`temp_space`	Gets the temp_space of this SqlTuningTaskSqlExecutionPlanStep.
`time`	Gets the time of this SqlTuningTaskSqlExecutionPlanStep.

__init__(**kwargs)¶

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

Parameters:

plan_hash_value (int) – The value to assign to the plan_hash_value property of this SqlTuningTaskSqlExecutionPlanStep.
step_id (int) – The value to assign to the step_id property of this SqlTuningTaskSqlExecutionPlanStep.
parent_step_id (int) – The value to assign to the parent_step_id property of this SqlTuningTaskSqlExecutionPlanStep.
position (int) – The value to assign to the position property of this SqlTuningTaskSqlExecutionPlanStep.
operation (str) – The value to assign to the operation property of this SqlTuningTaskSqlExecutionPlanStep.
options (str) – The value to assign to the options property of this SqlTuningTaskSqlExecutionPlanStep.
optimizer_mode (str) – The value to assign to the optimizer_mode property of this SqlTuningTaskSqlExecutionPlanStep.
cost (float) – The value to assign to the cost property of this SqlTuningTaskSqlExecutionPlanStep.
cardinality (int) – The value to assign to the cardinality property of this SqlTuningTaskSqlExecutionPlanStep.
bytes (int) – The value to assign to the bytes property of this SqlTuningTaskSqlExecutionPlanStep.
cpu_cost (float) – The value to assign to the cpu_cost property of this SqlTuningTaskSqlExecutionPlanStep.
io_cost (float) – The value to assign to the io_cost property of this SqlTuningTaskSqlExecutionPlanStep.
temp_space (int) – The value to assign to the temp_space property of this SqlTuningTaskSqlExecutionPlanStep.
time (int) – The value to assign to the time property of this SqlTuningTaskSqlExecutionPlanStep.
object_node (str) – The value to assign to the object_node property of this SqlTuningTaskSqlExecutionPlanStep.
object_owner (str) – The value to assign to the object_owner property of this SqlTuningTaskSqlExecutionPlanStep.
object_name (str) – The value to assign to the object_name property of this SqlTuningTaskSqlExecutionPlanStep.
object_position (int) – The value to assign to the object_position property of this SqlTuningTaskSqlExecutionPlanStep.
object_type (str) – The value to assign to the object_type property of this SqlTuningTaskSqlExecutionPlanStep.
partition_start (str) – The value to assign to the partition_start property of this SqlTuningTaskSqlExecutionPlanStep.
partition_stop (str) – The value to assign to the partition_stop property of this SqlTuningTaskSqlExecutionPlanStep.
partition_id (int) – The value to assign to the partition_id property of this SqlTuningTaskSqlExecutionPlanStep.
remarks (str) – The value to assign to the remarks property of this SqlTuningTaskSqlExecutionPlanStep.
number_of_search_column (int) – The value to assign to the number_of_search_column property of this SqlTuningTaskSqlExecutionPlanStep.
other (str) – The value to assign to the other property of this SqlTuningTaskSqlExecutionPlanStep.
other_tag (str) – The value to assign to the other_tag property of this SqlTuningTaskSqlExecutionPlanStep.
attribute (str) – The value to assign to the attribute property of this SqlTuningTaskSqlExecutionPlanStep.
access_predicates (str) – The value to assign to the access_predicates property of this SqlTuningTaskSqlExecutionPlanStep.
filter_predicates (str) – The value to assign to the filter_predicates property of this SqlTuningTaskSqlExecutionPlanStep.

access_predicates¶

Gets the access_predicates of this SqlTuningTaskSqlExecutionPlanStep. The predicates used to locate rows in an access structure. For example, start or stop predicates for an index range scan.

Returns:	The access_predicates of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	str

attribute¶

Gets the attribute of this SqlTuningTaskSqlExecutionPlanStep. The text string identifying the type of execution plan.

Returns:	The attribute of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	str

bytes¶

Gets the bytes of this SqlTuningTaskSqlExecutionPlanStep. The number of bytes returned by the current operation.

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

cardinality¶

Gets the cardinality of this SqlTuningTaskSqlExecutionPlanStep. The number of rows returned by the current operation (estimated by the CBO).

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

cost¶

Gets the cost of this SqlTuningTaskSqlExecutionPlanStep. The cost of the current operation estimated by the cost-based optimizer (CBO).

Returns:	The cost of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	float

cpu_cost¶

Gets the cpu_cost of this SqlTuningTaskSqlExecutionPlanStep. The CPU cost of the current operation.

Returns:	The cpu_cost of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	float

filter_predicates¶

Gets the filter_predicates of this SqlTuningTaskSqlExecutionPlanStep. The predicates used to filter rows before producing them.

Returns:	The filter_predicates of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	str

io_cost¶

Gets the io_cost of this SqlTuningTaskSqlExecutionPlanStep. The I/O cost of the current operation.

Returns:	The io_cost of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	float

number_of_search_column¶

Gets the number_of_search_column of this SqlTuningTaskSqlExecutionPlanStep. Number of index columns with start and stop keys (that is, the number of columns with matching predicates).

Returns:	The number_of_search_column of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	int

object_name¶

Gets the object_name of this SqlTuningTaskSqlExecutionPlanStep. The name of the object.

Returns:	The object_name of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	str

object_node¶

Gets the object_node of this SqlTuningTaskSqlExecutionPlanStep. The name of the database link used to reference the object.

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

object_owner¶

Gets the object_owner of this SqlTuningTaskSqlExecutionPlanStep. The owner of the object.

Returns:	The object_owner of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	str

object_position¶

Gets the object_position of this SqlTuningTaskSqlExecutionPlanStep. The numbered position of the object name in the original SQL statement.

Returns:	The object_position of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	int

object_type¶

Gets the object_type of this SqlTuningTaskSqlExecutionPlanStep. The descriptive modifier that further describes the type of object.

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

operation¶

Gets the operation of this SqlTuningTaskSqlExecutionPlanStep. The name of the operation performed at this step.

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

optimizer_mode¶

Gets the optimizer_mode of this SqlTuningTaskSqlExecutionPlanStep. The current mode of the optimizer, such as all_rows, first_rows_n (where n = 1, 10, 100, 1000, and so on).

Returns:	The optimizer_mode of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	str

options¶

Gets the options of this SqlTuningTaskSqlExecutionPlanStep. The options used for the operation performed at this step.

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

other¶

Gets the other of this SqlTuningTaskSqlExecutionPlanStep. Information about parallel execution servers and parallel queries

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

other_tag¶

Gets the other_tag of this SqlTuningTaskSqlExecutionPlanStep. Describes the function of the SQL text in the OTHER column.

Returns:	The other_tag of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	str

parent_step_id¶

Gets the parent_step_id of this SqlTuningTaskSqlExecutionPlanStep. The ID of the next step that operates on the results of this step. This is not the OCID.

Returns:	The parent_step_id of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	int

partition_id¶

Gets the partition_id of this SqlTuningTaskSqlExecutionPlanStep. The ID of the step in the execution plan that has computed the pair of values of partitionStart and partitionStop.

Returns:	The partition_id of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	int

partition_start¶

Gets the partition_start of this SqlTuningTaskSqlExecutionPlanStep. A step may get data from a range of partitions of a partitioned object, such as table or index, based on predicates and sorting order. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.

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

partition_stop¶

Gets the partition_stop of this SqlTuningTaskSqlExecutionPlanStep. A step may get data from a range of partitions of a partitioned object, such as table or index, based on predicates and sorting order. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.

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

plan_hash_value¶

Gets the plan_hash_value of this SqlTuningTaskSqlExecutionPlanStep. The numerical representation of the SQL execution plan.

Returns:	The plan_hash_value of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	int

position¶

Gets the position of this SqlTuningTaskSqlExecutionPlanStep. The order of processing for steps with the same parent ID.

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

remarks¶

Gets the remarks of this SqlTuningTaskSqlExecutionPlanStep. The place for comments that can be added to the steps of the execution plan.

Returns:	The remarks of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	str

step_id¶

Gets the step_id of this SqlTuningTaskSqlExecutionPlanStep. The identification number of a step in the SQL execution plan. This is unique within the SQL execution plan. This is not the OCID.

Returns:	The step_id of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	int

temp_space¶

Gets the temp_space of this SqlTuningTaskSqlExecutionPlanStep. The temporary space usage (in bytes) of the operation (sort or hash-join) as estimated by the CBO.

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

time¶

Gets the time of this SqlTuningTaskSqlExecutionPlanStep. The elapsed time (in seconds) of the operation as estimated by the CBO.

Returns:	The time of this SqlTuningTaskSqlExecutionPlanStep.
Return type:	int