SqlTuningAdvisorTaskSummaryFindingCounts¶
- class oci.database_management.models.SqlTuningAdvisorTaskSummaryFindingCounts(**kwargs)¶
Bases:
objectThe number of findings in the SQL Tuning Advisor summary report.
Methods:
__init__(**kwargs)Initializes a new SqlTuningAdvisorTaskSummaryFindingCounts object with values from keyword arguments.
Attributes:
[Required] Gets the alternate_plan of this SqlTuningAdvisorTaskSummaryFindingCounts.
[Required] Gets the implemented_sql_profile of this SqlTuningAdvisorTaskSummaryFindingCounts.
[Required] Gets the index of this SqlTuningAdvisorTaskSummaryFindingCounts.
[Required] Gets the recommended_sql_profile of this SqlTuningAdvisorTaskSummaryFindingCounts.
[Required] Gets the restructure of this SqlTuningAdvisorTaskSummaryFindingCounts.
[Required] Gets the statistics of this SqlTuningAdvisorTaskSummaryFindingCounts.
- __init__(**kwargs)¶
Initializes a new SqlTuningAdvisorTaskSummaryFindingCounts object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):
- Parameters
recommended_sql_profile (int) – The value to assign to the recommended_sql_profile property of this SqlTuningAdvisorTaskSummaryFindingCounts.
implemented_sql_profile (int) – The value to assign to the implemented_sql_profile property of this SqlTuningAdvisorTaskSummaryFindingCounts.
index (int) – The value to assign to the index property of this SqlTuningAdvisorTaskSummaryFindingCounts.
restructure (int) – The value to assign to the restructure property of this SqlTuningAdvisorTaskSummaryFindingCounts.
statistics (int) – The value to assign to the statistics property of this SqlTuningAdvisorTaskSummaryFindingCounts.
alternate_plan (int) – The value to assign to the alternate_plan property of this SqlTuningAdvisorTaskSummaryFindingCounts.
- property alternate_plan¶
[Required] Gets the alternate_plan of this SqlTuningAdvisorTaskSummaryFindingCounts. The number of distinct SQL statements with alternative plan recommendations.
- Returns
The alternate_plan of this SqlTuningAdvisorTaskSummaryFindingCounts.
- Return type
int
- property implemented_sql_profile¶
[Required] Gets the implemented_sql_profile of this SqlTuningAdvisorTaskSummaryFindingCounts. The number of distinct SQL statements with implemented SQL profiles.
- Returns
The implemented_sql_profile of this SqlTuningAdvisorTaskSummaryFindingCounts.
- Return type
int
- property index¶
[Required] Gets the index of this SqlTuningAdvisorTaskSummaryFindingCounts. The number of distinct SQL statements with index recommendations.
- Returns
The index of this SqlTuningAdvisorTaskSummaryFindingCounts.
- Return type
int
- property recommended_sql_profile¶
[Required] Gets the recommended_sql_profile of this SqlTuningAdvisorTaskSummaryFindingCounts. The number of distinct SQL statements with recommended SQL profiles.
- Returns
The recommended_sql_profile of this SqlTuningAdvisorTaskSummaryFindingCounts.
- Return type
int
- property restructure¶
[Required] Gets the restructure of this SqlTuningAdvisorTaskSummaryFindingCounts. The number of distinct SQL statements with restructured SQL recommendations.
- Returns
The restructure of this SqlTuningAdvisorTaskSummaryFindingCounts.
- Return type
int
- property statistics¶
[Required] Gets the statistics of this SqlTuningAdvisorTaskSummaryFindingCounts. The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
- Returns
The statistics of this SqlTuningAdvisorTaskSummaryFindingCounts.
- Return type
int