SqlTuningAdvisorTaskSummaryFindingBenefits¶

class oci.database_management.models.SqlTuningAdvisorTaskSummaryFindingBenefits(**kwargs)¶

Bases: object

The benefits of the findings in the SQL Tuning Advisor summary report.

Methods

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

Attributes

`db_time_after_implemented`	[Required] Gets the db_time_after_implemented of this SqlTuningAdvisorTaskSummaryFindingBenefits.
`db_time_after_recommended`	[Required] Gets the db_time_after_recommended of this SqlTuningAdvisorTaskSummaryFindingBenefits.
`db_time_before_implemented`	[Required] Gets the db_time_before_implemented of this SqlTuningAdvisorTaskSummaryFindingBenefits.
`db_time_before_recommended`	[Required] Gets the db_time_before_recommended of this SqlTuningAdvisorTaskSummaryFindingBenefits.

__init__(**kwargs)¶

Initializes a new SqlTuningAdvisorTaskSummaryFindingBenefits object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

db_time_before_recommended (int) – The value to assign to the db_time_before_recommended property of this SqlTuningAdvisorTaskSummaryFindingBenefits.
db_time_after_recommended (int) – The value to assign to the db_time_after_recommended property of this SqlTuningAdvisorTaskSummaryFindingBenefits.
db_time_after_implemented (int) – The value to assign to the db_time_after_implemented property of this SqlTuningAdvisorTaskSummaryFindingBenefits.
db_time_before_implemented (int) – The value to assign to the db_time_before_implemented property of this SqlTuningAdvisorTaskSummaryFindingBenefits.

db_time_after_implemented¶

[Required] Gets the db_time_after_implemented of this SqlTuningAdvisorTaskSummaryFindingBenefits. The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are implemented.

Returns:	The db_time_after_implemented of this SqlTuningAdvisorTaskSummaryFindingBenefits.
Return type:	int

db_time_after_recommended¶

[Required] Gets the db_time_after_recommended of this SqlTuningAdvisorTaskSummaryFindingBenefits. The estimated database time of the above SQL statements, if SQL Tuning Advisor recommendations are implemented.

Returns:	The db_time_after_recommended of this SqlTuningAdvisorTaskSummaryFindingBenefits.
Return type:	int

db_time_before_implemented¶

[Required] Gets the db_time_before_implemented of this SqlTuningAdvisorTaskSummaryFindingBenefits. The actual database time of the above SQL statements, before SQL Tuning Advisor recommendations are implemented.

Returns:	The db_time_before_implemented of this SqlTuningAdvisorTaskSummaryFindingBenefits.
Return type:	int

db_time_before_recommended¶

[Required] Gets the db_time_before_recommended of this SqlTuningAdvisorTaskSummaryFindingBenefits. The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are not implemented.

Returns:	The db_time_before_recommended of this SqlTuningAdvisorTaskSummaryFindingBenefits.
Return type:	int