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.

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

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

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

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

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

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