SqlTuningTaskSqlExecutionPlanStep

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

Bases: object

A step of a 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. 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. Text string identifying the type of the execution plan.

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

Gets the bytes of this SqlTuningTaskSqlExecutionPlanStep. Number of bytes returned by the current operation.

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

Gets the cardinality of this SqlTuningTaskSqlExecutionPlanStep. 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. 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. 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. Name of the object.

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

Gets the object_node of this SqlTuningTaskSqlExecutionPlanStep. 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. Owner of the object.

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

Gets the object_position of this SqlTuningTaskSqlExecutionPlanStep. 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. 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. 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. Current mode of the optimizer, such as all_rows, first_rows_n (where n = 1, 10, 100, 1000 etc).

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

Gets the options of this SqlTuningTaskSqlExecutionPlanStep. 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. ID of the next step that operates on the results of this step. It 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 the 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 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 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. Numerical representation of the execution plan

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

Gets the position of this SqlTuningTaskSqlExecutionPlanStep. 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. 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. Identification number for this step in the execution plan. It is unique within the execution plan. It is not the OCID.

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

Gets the temp_space of this SqlTuningTaskSqlExecutionPlanStep. 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. Elapsed time (in seconds) of the operation as estimated by the CBO.

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