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.

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

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

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

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

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

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

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

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

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

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

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

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. The 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. The 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. 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

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

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