SqlTuningAdvisorTaskFindingSummary

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

Bases: object

A summary for all the findings of objects in a tuning task that match a given certain filter. Includes what kind of findings were found, whether benefits were analyzed, and how many benefits can be obtained.

Methods

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

Attributes

db_time_benefit Gets the db_time_benefit of this SqlTuningAdvisorTaskFindingSummary.
is_alternative_plan_finding_present Gets the is_alternative_plan_finding_present of this SqlTuningAdvisorTaskFindingSummary.
is_error_finding_present Gets the is_error_finding_present of this SqlTuningAdvisorTaskFindingSummary.
is_index_finding_present Gets the is_index_finding_present of this SqlTuningAdvisorTaskFindingSummary.
is_miscellaneous_finding_present Gets the is_miscellaneous_finding_present of this SqlTuningAdvisorTaskFindingSummary.
is_restructure_sql_finding_present Gets the is_restructure_sql_finding_present of this SqlTuningAdvisorTaskFindingSummary.
is_sql_profile_finding_implemented Gets the is_sql_profile_finding_implemented of this SqlTuningAdvisorTaskFindingSummary.
is_sql_profile_finding_present Gets the is_sql_profile_finding_present of this SqlTuningAdvisorTaskFindingSummary.
is_stats_finding_present Gets the is_stats_finding_present of this SqlTuningAdvisorTaskFindingSummary.
is_timeout_finding_present Gets the is_timeout_finding_present of this SqlTuningAdvisorTaskFindingSummary.
parsing_schema [Required] Gets the parsing_schema of this SqlTuningAdvisorTaskFindingSummary.
per_execution_percentage Gets the per_execution_percentage of this SqlTuningAdvisorTaskFindingSummary.
sql_key [Required] Gets the sql_key of this SqlTuningAdvisorTaskFindingSummary.
sql_text [Required] Gets the sql_text of this SqlTuningAdvisorTaskFindingSummary.
sql_tuning_advisor_task_id [Required] Gets the sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskFindingSummary.
sql_tuning_advisor_task_object_execution_id [Required] Gets the sql_tuning_advisor_task_object_execution_id of this SqlTuningAdvisorTaskFindingSummary.
sql_tuning_advisor_task_object_id [Required] Gets the sql_tuning_advisor_task_object_id of this SqlTuningAdvisorTaskFindingSummary.
__init__(**kwargs)

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

Parameters:
  • sql_tuning_advisor_task_id (int) – The value to assign to the sql_tuning_advisor_task_id property of this SqlTuningAdvisorTaskFindingSummary.
  • sql_tuning_advisor_task_object_id (int) – The value to assign to the sql_tuning_advisor_task_object_id property of this SqlTuningAdvisorTaskFindingSummary.
  • sql_tuning_advisor_task_object_execution_id (int) – The value to assign to the sql_tuning_advisor_task_object_execution_id property of this SqlTuningAdvisorTaskFindingSummary.
  • sql_text (str) – The value to assign to the sql_text property of this SqlTuningAdvisorTaskFindingSummary.
  • parsing_schema (str) – The value to assign to the parsing_schema property of this SqlTuningAdvisorTaskFindingSummary.
  • sql_key (str) – The value to assign to the sql_key property of this SqlTuningAdvisorTaskFindingSummary.
  • db_time_benefit (float) – The value to assign to the db_time_benefit property of this SqlTuningAdvisorTaskFindingSummary.
  • per_execution_percentage (int) – The value to assign to the per_execution_percentage property of this SqlTuningAdvisorTaskFindingSummary.
  • is_stats_finding_present (bool) – The value to assign to the is_stats_finding_present property of this SqlTuningAdvisorTaskFindingSummary.
  • is_sql_profile_finding_present (bool) – The value to assign to the is_sql_profile_finding_present property of this SqlTuningAdvisorTaskFindingSummary.
  • is_sql_profile_finding_implemented (bool) – The value to assign to the is_sql_profile_finding_implemented property of this SqlTuningAdvisorTaskFindingSummary.
  • is_index_finding_present (bool) – The value to assign to the is_index_finding_present property of this SqlTuningAdvisorTaskFindingSummary.
  • is_restructure_sql_finding_present (bool) – The value to assign to the is_restructure_sql_finding_present property of this SqlTuningAdvisorTaskFindingSummary.
  • is_alternative_plan_finding_present (bool) – The value to assign to the is_alternative_plan_finding_present property of this SqlTuningAdvisorTaskFindingSummary.
  • is_miscellaneous_finding_present (bool) – The value to assign to the is_miscellaneous_finding_present property of this SqlTuningAdvisorTaskFindingSummary.
  • is_error_finding_present (bool) – The value to assign to the is_error_finding_present property of this SqlTuningAdvisorTaskFindingSummary.
  • is_timeout_finding_present (bool) – The value to assign to the is_timeout_finding_present property of this SqlTuningAdvisorTaskFindingSummary.
db_time_benefit

Gets the db_time_benefit of this SqlTuningAdvisorTaskFindingSummary. Time benefit in seconds for the highest-rated finding for this object.

Returns:The db_time_benefit of this SqlTuningAdvisorTaskFindingSummary.
Return type:float
is_alternative_plan_finding_present

Gets the is_alternative_plan_finding_present of this SqlTuningAdvisorTaskFindingSummary. Whether an alternative execution plan was found for this SQL statement.

Returns:The is_alternative_plan_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Return type:bool
is_error_finding_present

Gets the is_error_finding_present of this SqlTuningAdvisorTaskFindingSummary. Whether there is an error in this SQL statement.

Returns:The is_error_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Return type:bool
is_index_finding_present

Gets the is_index_finding_present of this SqlTuningAdvisorTaskFindingSummary. Whether an index recommendation was found for this SQL statement.

Returns:The is_index_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Return type:bool
is_miscellaneous_finding_present

Gets the is_miscellaneous_finding_present of this SqlTuningAdvisorTaskFindingSummary. Whether a miscellaneous finding was found for this SQL statement.

Returns:The is_miscellaneous_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Return type:bool
is_restructure_sql_finding_present

Gets the is_restructure_sql_finding_present of this SqlTuningAdvisorTaskFindingSummary. Whether a restructure SQL recommendation was found for this SQL statement.

Returns:The is_restructure_sql_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Return type:bool
is_sql_profile_finding_implemented

Gets the is_sql_profile_finding_implemented of this SqlTuningAdvisorTaskFindingSummary. Whether a SQL Profile recommendation has been implemented for this SQL statement.

Returns:The is_sql_profile_finding_implemented of this SqlTuningAdvisorTaskFindingSummary.
Return type:bool
is_sql_profile_finding_present

Gets the is_sql_profile_finding_present of this SqlTuningAdvisorTaskFindingSummary. Whether a SQL Profile recommendation was found for this SQL statement.

Returns:The is_sql_profile_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Return type:bool
is_stats_finding_present

Gets the is_stats_finding_present of this SqlTuningAdvisorTaskFindingSummary. Whether a statistics recommendation was found for this SQL statement.

Returns:The is_stats_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Return type:bool
is_timeout_finding_present

Gets the is_timeout_finding_present of this SqlTuningAdvisorTaskFindingSummary. Whether the task timed out.

Returns:The is_timeout_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Return type:bool
parsing_schema

[Required] Gets the parsing_schema of this SqlTuningAdvisorTaskFindingSummary. Parsing schema of the object.

Returns:The parsing_schema of this SqlTuningAdvisorTaskFindingSummary.
Return type:str
per_execution_percentage

Gets the per_execution_percentage of this SqlTuningAdvisorTaskFindingSummary. The per-execution percentage benefit.

Returns:The per_execution_percentage of this SqlTuningAdvisorTaskFindingSummary.
Return type:int
sql_key

[Required] Gets the sql_key of this SqlTuningAdvisorTaskFindingSummary. Unique key of this SQL statement

Returns:The sql_key of this SqlTuningAdvisorTaskFindingSummary.
Return type:str
sql_text

[Required] Gets the sql_text of this SqlTuningAdvisorTaskFindingSummary. Text of the SQL statement.

Returns:The sql_text of this SqlTuningAdvisorTaskFindingSummary.
Return type:str
sql_tuning_advisor_task_id

[Required] Gets the sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskFindingSummary. Unique identifier of the task. It is not the OCID.

Returns:The sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskFindingSummary.
Return type:int
sql_tuning_advisor_task_object_execution_id

[Required] Gets the sql_tuning_advisor_task_object_execution_id of this SqlTuningAdvisorTaskFindingSummary. Execution id of the analyzed SQL object. It is not the OCID.

Returns:The sql_tuning_advisor_task_object_execution_id of this SqlTuningAdvisorTaskFindingSummary.
Return type:int
sql_tuning_advisor_task_object_id

[Required] Gets the sql_tuning_advisor_task_object_id of this SqlTuningAdvisorTaskFindingSummary. Key of the object to which these recommendations apply. It is not the OCID.

Returns:The sql_tuning_advisor_task_object_id of this SqlTuningAdvisorTaskFindingSummary.
Return type:int