SqlTuningAdvisorTaskSummaryFindingCounts

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

Bases: object

The finding counts data for the SQL Tuning Advisor summary report.

Methods

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

Attributes

alternate_plan [Required] Gets the alternate_plan of this SqlTuningAdvisorTaskSummaryFindingCounts.
implemented_sql_profile [Required] Gets the implemented_sql_profile of this SqlTuningAdvisorTaskSummaryFindingCounts.
index [Required] Gets the index of this SqlTuningAdvisorTaskSummaryFindingCounts.
recommended_sql_profile [Required] Gets the recommended_sql_profile of this SqlTuningAdvisorTaskSummaryFindingCounts.
restructure [Required] Gets the restructure of this SqlTuningAdvisorTaskSummaryFindingCounts.
statistics [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.
alternate_plan

[Required] Gets the alternate_plan of this SqlTuningAdvisorTaskSummaryFindingCounts. The count of distinct SQL statements with alternative plan recommendations.

Returns:The alternate_plan of this SqlTuningAdvisorTaskSummaryFindingCounts.
Return type:int
implemented_sql_profile

[Required] Gets the implemented_sql_profile of this SqlTuningAdvisorTaskSummaryFindingCounts. The count of distinct SQL statements with implemented SQL profiles.

Returns:The implemented_sql_profile of this SqlTuningAdvisorTaskSummaryFindingCounts.
Return type:int
index

[Required] Gets the index of this SqlTuningAdvisorTaskSummaryFindingCounts. The count of distinct SQL statements with index recommendations.

Returns:The index of this SqlTuningAdvisorTaskSummaryFindingCounts.
Return type:int
recommended_sql_profile

[Required] Gets the recommended_sql_profile of this SqlTuningAdvisorTaskSummaryFindingCounts. The count of distinct SQL statements with recommended SQL profiles.

Returns:The recommended_sql_profile of this SqlTuningAdvisorTaskSummaryFindingCounts.
Return type:int
restructure

[Required] Gets the restructure of this SqlTuningAdvisorTaskSummaryFindingCounts. The count of distinct SQL statements with restructure SQL recommendations.

Returns:The restructure of this SqlTuningAdvisorTaskSummaryFindingCounts.
Return type:int
statistics

[Required] Gets the statistics of this SqlTuningAdvisorTaskSummaryFindingCounts. The count of distinct SQL statements with stale/missing optimizer statistics recommendations.

Returns:The statistics of this SqlTuningAdvisorTaskSummaryFindingCounts.
Return type:int