public static class SqlTuningAdvisorTaskFindingSummary.Builder extends Object
Constructor and Description |
---|
Builder() |
Modifier and Type | Method and Description |
---|---|
SqlTuningAdvisorTaskFindingSummary |
build() |
SqlTuningAdvisorTaskFindingSummary.Builder |
copy(SqlTuningAdvisorTaskFindingSummary model) |
SqlTuningAdvisorTaskFindingSummary.Builder |
dbTimeBenefit(Float dbTimeBenefit)
The time benefit (in seconds) for the highest-rated finding for this object.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
isAlternativePlanFindingPresent(Boolean isAlternativePlanFindingPresent)
Indicates whether an alternative execution plan was reported for this SQL statement.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
isErrorFindingPresent(Boolean isErrorFindingPresent)
Indicates whether there is an error in this SQL statement.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
isIndexFindingPresent(Boolean isIndexFindingPresent)
Indicates whether an index recommendation was reported for this SQL statement.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
isMiscellaneousFindingPresent(Boolean isMiscellaneousFindingPresent)
Indicates whether a miscellaneous finding was reported for this SQL statement.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
isRestructureSqlFindingPresent(Boolean isRestructureSqlFindingPresent)
Indicates whether a restructure SQL recommendation was reported for this SQL statement.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
isSqlProfileFindingImplemented(Boolean isSqlProfileFindingImplemented)
Indicates whether a SQL Profile recommendation has been implemented for this SQL
statement.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
isSqlProfileFindingPresent(Boolean isSqlProfileFindingPresent)
Indicates whether a SQL Profile recommendation was reported for this SQL statement.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
isStatsFindingPresent(Boolean isStatsFindingPresent)
Indicates whether a statistics recommendation was reported for this SQL statement.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
isTimeoutFindingPresent(Boolean isTimeoutFindingPresent)
Indicates whether the task timed out.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
parsingSchema(String parsingSchema)
The parsing schema of the object.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
perExecutionPercentage(Integer perExecutionPercentage)
The per-execution percentage benefit.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
sqlKey(String sqlKey)
The unique key of this SQL statement.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
sqlText(String sqlText)
The text of the SQL statement.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
sqlTuningAdvisorTaskId(Long sqlTuningAdvisorTaskId)
The unique identifier of the SQL Tuning Advisor task.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
sqlTuningAdvisorTaskObjectExecutionId(Long sqlTuningAdvisorTaskObjectExecutionId)
The execution id of the analyzed SQL object.
|
SqlTuningAdvisorTaskFindingSummary.Builder |
sqlTuningAdvisorTaskObjectId(Long sqlTuningAdvisorTaskObjectId)
The key of the object to which these recommendations apply.
|
public SqlTuningAdvisorTaskFindingSummary.Builder sqlTuningAdvisorTaskId(Long sqlTuningAdvisorTaskId)
The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
sqlTuningAdvisorTaskId
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder sqlTuningAdvisorTaskObjectId(Long sqlTuningAdvisorTaskObjectId)
The key of the object to which these recommendations apply. This is not the OCID.
sqlTuningAdvisorTaskObjectId
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder sqlTuningAdvisorTaskObjectExecutionId(Long sqlTuningAdvisorTaskObjectExecutionId)
The execution id of the analyzed SQL object. This is not the OCID.
sqlTuningAdvisorTaskObjectExecutionId
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder sqlText(String sqlText)
The text of the SQL statement.
sqlText
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder parsingSchema(String parsingSchema)
The parsing schema of the object.
parsingSchema
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder sqlKey(String sqlKey)
The unique key of this SQL statement.
sqlKey
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder dbTimeBenefit(Float dbTimeBenefit)
The time benefit (in seconds) for the highest-rated finding for this object.
dbTimeBenefit
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder perExecutionPercentage(Integer perExecutionPercentage)
The per-execution percentage benefit.
perExecutionPercentage
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder isStatsFindingPresent(Boolean isStatsFindingPresent)
Indicates whether a statistics recommendation was reported for this SQL statement.
isStatsFindingPresent
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder isSqlProfileFindingPresent(Boolean isSqlProfileFindingPresent)
Indicates whether a SQL Profile recommendation was reported for this SQL statement.
isSqlProfileFindingPresent
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder isSqlProfileFindingImplemented(Boolean isSqlProfileFindingImplemented)
Indicates whether a SQL Profile recommendation has been implemented for this SQL statement.
isSqlProfileFindingImplemented
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder isIndexFindingPresent(Boolean isIndexFindingPresent)
Indicates whether an index recommendation was reported for this SQL statement.
isIndexFindingPresent
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder isRestructureSqlFindingPresent(Boolean isRestructureSqlFindingPresent)
Indicates whether a restructure SQL recommendation was reported for this SQL statement.
isRestructureSqlFindingPresent
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder isAlternativePlanFindingPresent(Boolean isAlternativePlanFindingPresent)
Indicates whether an alternative execution plan was reported for this SQL statement.
isAlternativePlanFindingPresent
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder isMiscellaneousFindingPresent(Boolean isMiscellaneousFindingPresent)
Indicates whether a miscellaneous finding was reported for this SQL statement.
isMiscellaneousFindingPresent
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder isErrorFindingPresent(Boolean isErrorFindingPresent)
Indicates whether there is an error in this SQL statement.
isErrorFindingPresent
- the value to setpublic SqlTuningAdvisorTaskFindingSummary.Builder isTimeoutFindingPresent(Boolean isTimeoutFindingPresent)
Indicates whether the task timed out.
isTimeoutFindingPresent
- the value to setpublic SqlTuningAdvisorTaskFindingSummary build()
public SqlTuningAdvisorTaskFindingSummary.Builder copy(SqlTuningAdvisorTaskFindingSummary model)
Copyright © 2016–2024. All rights reserved.