SqlTuningAdvisorTaskSummaryFindingBenefits¶
- class oci.database_management.models.SqlTuningAdvisorTaskSummaryFindingBenefits(**kwargs)¶
Bases:
objectThe 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:
[Required] Gets the db_time_after_implemented of this SqlTuningAdvisorTaskSummaryFindingBenefits.
[Required] Gets the db_time_after_recommended of this SqlTuningAdvisorTaskSummaryFindingBenefits.
[Required] Gets the db_time_before_implemented of this SqlTuningAdvisorTaskSummaryFindingBenefits.
[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.
- property 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
- property 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
- property 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
- property 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