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.

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

[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

[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