SqlTuningAdvisorTaskSummaryFindingCounts

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

Bases: object

The number of findings in 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.

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