SqlTuningAdvisorTaskFindingSummary¶
- class oci.database_management.models.SqlTuningAdvisorTaskFindingSummary(**kwargs)¶
Bases:
objectA 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:
Gets the db_time_benefit of this SqlTuningAdvisorTaskFindingSummary.
Gets the is_alternative_plan_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Gets the is_error_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Gets the is_index_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Gets the is_miscellaneous_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Gets the is_restructure_sql_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Gets the is_sql_profile_finding_implemented of this SqlTuningAdvisorTaskFindingSummary.
Gets the is_sql_profile_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Gets the is_stats_finding_present of this SqlTuningAdvisorTaskFindingSummary.
Gets the is_timeout_finding_present of this SqlTuningAdvisorTaskFindingSummary.
[Required] Gets the parsing_schema of this SqlTuningAdvisorTaskFindingSummary.
Gets the per_execution_percentage of this SqlTuningAdvisorTaskFindingSummary.
[Required] Gets the sql_key of this SqlTuningAdvisorTaskFindingSummary.
[Required] Gets the sql_text of this SqlTuningAdvisorTaskFindingSummary.
[Required] Gets the sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskFindingSummary.
[Required] Gets the sql_tuning_advisor_task_object_execution_id of this SqlTuningAdvisorTaskFindingSummary.
[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