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.

property 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

property 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

property 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

property 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

property 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

property 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

property 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

property 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

property 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

property object_name

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

Returns

The object_name of this SqlTuningTaskSqlExecutionPlanStep.

Return type

str

property 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

property object_owner

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

Returns

The object_owner of this SqlTuningTaskSqlExecutionPlanStep.

Return type

str

property 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

property 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

property 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

property 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

property 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

property other

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

Returns

The other of this SqlTuningTaskSqlExecutionPlanStep.

Return type

str

property 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

property 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

property 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

property 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

property 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

property 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

property 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

property 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

property 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

property 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

property 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