SqlTuningAdvisorTaskFindingSummary

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

Bases: object

A summary of the findings of the objects in a tuning task that match a given filter. This includes the kind of findings that were reported, whether the benefits were analyzed, and the number of benefits 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.

property db_time_benefit

Gets the db_time_benefit of this SqlTuningAdvisorTaskFindingSummary. The time benefit (in seconds) for the highest-rated finding for this object.

Returns

The db_time_benefit of this SqlTuningAdvisorTaskFindingSummary.

Return type

float

property is_alternative_plan_finding_present

Gets the is_alternative_plan_finding_present of this SqlTuningAdvisorTaskFindingSummary. Indicates whether an alternative execution plan was reported for this SQL statement.

Returns

The is_alternative_plan_finding_present of this SqlTuningAdvisorTaskFindingSummary.

Return type

bool

property is_error_finding_present

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

Returns

The is_error_finding_present of this SqlTuningAdvisorTaskFindingSummary.

Return type

bool

property is_index_finding_present

Gets the is_index_finding_present of this SqlTuningAdvisorTaskFindingSummary. Indicates whether an index recommendation was reported for this SQL statement.

Returns

The is_index_finding_present of this SqlTuningAdvisorTaskFindingSummary.

Return type

bool

property is_miscellaneous_finding_present

Gets the is_miscellaneous_finding_present of this SqlTuningAdvisorTaskFindingSummary. Indicates whether a miscellaneous finding was reported for this SQL statement.

Returns

The is_miscellaneous_finding_present of this SqlTuningAdvisorTaskFindingSummary.

Return type

bool

property is_restructure_sql_finding_present

Gets the is_restructure_sql_finding_present of this SqlTuningAdvisorTaskFindingSummary. Indicates whether a restructure SQL recommendation was reported for this SQL statement.

Returns

The is_restructure_sql_finding_present of this SqlTuningAdvisorTaskFindingSummary.

Return type

bool

property is_sql_profile_finding_implemented

Gets the is_sql_profile_finding_implemented of this SqlTuningAdvisorTaskFindingSummary. Indicates 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

property is_sql_profile_finding_present

Gets the is_sql_profile_finding_present of this SqlTuningAdvisorTaskFindingSummary. Indicates whether a SQL Profile recommendation was reported for this SQL statement.

Returns

The is_sql_profile_finding_present of this SqlTuningAdvisorTaskFindingSummary.

Return type

bool

property is_stats_finding_present

Gets the is_stats_finding_present of this SqlTuningAdvisorTaskFindingSummary. Indicates whether a statistics recommendation was reported for this SQL statement.

Returns

The is_stats_finding_present of this SqlTuningAdvisorTaskFindingSummary.

Return type

bool

property is_timeout_finding_present

Gets the is_timeout_finding_present of this SqlTuningAdvisorTaskFindingSummary. Indicates whether the task timed out.

Returns

The is_timeout_finding_present of this SqlTuningAdvisorTaskFindingSummary.

Return type

bool

property parsing_schema

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

Returns

The parsing_schema of this SqlTuningAdvisorTaskFindingSummary.

Return type

str

property 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

property sql_key

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

Returns

The sql_key of this SqlTuningAdvisorTaskFindingSummary.

Return type

str

property sql_text

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

Returns

The sql_text of this SqlTuningAdvisorTaskFindingSummary.

Return type

str

property sql_tuning_advisor_task_id

[Required] Gets the sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskFindingSummary. The unique identifier of the SQL Tuning Advisor task. This is not the OCID.

Returns

The sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskFindingSummary.

Return type

int

property sql_tuning_advisor_task_object_execution_id

[Required] Gets the sql_tuning_advisor_task_object_execution_id of this SqlTuningAdvisorTaskFindingSummary. The execution id of the analyzed SQL object. This is not the OCID.

Returns

The sql_tuning_advisor_task_object_execution_id of this SqlTuningAdvisorTaskFindingSummary.

Return type

int

property sql_tuning_advisor_task_object_id

[Required] Gets the sql_tuning_advisor_task_object_id of this SqlTuningAdvisorTaskFindingSummary. The key of the object to which these recommendations apply. This is not the OCID.

Returns

The sql_tuning_advisor_task_object_id of this SqlTuningAdvisorTaskFindingSummary.

Return type

int