SqlPlanBaseline.Builder (Oracle Cloud Infrastructure Java SDK

java.lang.Object
- com.oracle.bmc.databasemanagement.model.SqlPlanBaseline.Builder

Enclosing class:: SqlPlanBaseline

public static class SqlPlanBaseline.Builder
extends Object

Constructor Summary

Constructors
Constructor and Description

Builder()

Constructors
Constructor and Description
`Builder()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`SqlPlanBaseline.Builder`	`accepted(SqlPlanBaseline.Accepted accepted)` Indicates whether the plan baseline is accepted (`YES`) or not (`NO`).
`SqlPlanBaseline.Builder`	`action(String action)` The application action.
`SqlPlanBaseline.Builder`	`adaptive(SqlPlanBaseline.Adaptive adaptive)` Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.
`SqlPlanBaseline.Builder`	`autoPurge(SqlPlanBaseline.AutoPurge autoPurge)` Indicates whether the plan baseline is auto-purged (`YES`) or not (`NO`).
`SqlPlanBaseline`	`build()`
`SqlPlanBaseline.Builder`	`copy(SqlPlanBaseline model)`
`SqlPlanBaseline.Builder`	`enabled(SqlPlanBaseline.Enabled enabled)` Indicates whether the plan baseline is enabled (`YES`) or disabled (`NO`).
`SqlPlanBaseline.Builder`	`executionPlan(String executionPlan)` The execution plan for the SQL statement.
`SqlPlanBaseline.Builder`	`fixed(SqlPlanBaseline.Fixed fixed)` Indicates whether the plan baseline is fixed (`YES`) or not (`NO`).
`SqlPlanBaseline.Builder`	`module(String module)` The application module name.
`SqlPlanBaseline.Builder`	`origin(SqlPlanBaselineOrigin origin)` The origin of the SQL plan baseline.
`SqlPlanBaseline.Builder`	`planName(String planName)` The unique plan identifier.
`SqlPlanBaseline.Builder`	`reproduced(SqlPlanBaseline.Reproduced reproduced)` Indicates whether the optimizer was able to reproduce the plan (`YES`) or not (`NO`).
`SqlPlanBaseline.Builder`	`sqlHandle(String sqlHandle)` The unique SQL identifier.
`SqlPlanBaseline.Builder`	`sqlText(String sqlText)` The SQL text.
`SqlPlanBaseline.Builder`	`timeCreated(Date timeCreated)` The date and time when the plan baseline was created.
`SqlPlanBaseline.Builder`	`timeLastExecuted(Date timeLastExecuted)` The date and time when the plan baseline was last executed.
`SqlPlanBaseline.Builder`	`timeLastModified(Date timeLastModified)` The date and time when the plan baseline was last modified.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - Builder
```
public Builder()
```
- Method Detail
  - planName
```
public SqlPlanBaseline.Builder planName(String planName)
```
    The unique plan identifier.
    
    Parameters:
    
    planName - the value to set
    
    Returns:
    
    this builder
  - sqlHandle
```
public SqlPlanBaseline.Builder sqlHandle(String sqlHandle)
```
    The unique SQL identifier.
    
    Parameters:
    
    sqlHandle - the value to set
    
    Returns:
    
    this builder
  - sqlText
```
public SqlPlanBaseline.Builder sqlText(String sqlText)
```
    The SQL text.
    
    Parameters:
    
    sqlText - the value to set
    
    Returns:
    
    this builder
  - origin
```
public SqlPlanBaseline.Builder origin(SqlPlanBaselineOrigin origin)
```
    The origin of the SQL plan baseline.
    
    Parameters:
    
    origin - the value to set
    
    Returns:
    
    this builder
  - timeCreated
```
public SqlPlanBaseline.Builder timeCreated(Date timeCreated)
```
    The date and time when the plan baseline was created.
    
    Parameters:
    
    timeCreated - the value to set
    
    Returns:
    
    this builder
  - timeLastModified
```
public SqlPlanBaseline.Builder timeLastModified(Date timeLastModified)
```
    The date and time when the plan baseline was last modified.
    
    Parameters:
    
    timeLastModified - the value to set
    
    Returns:
    
    this builder
  - timeLastExecuted
```
public SqlPlanBaseline.Builder timeLastExecuted(Date timeLastExecuted)
```
    The date and time when the plan baseline was last executed.
    
    *Note:** For performance reasons, database does not update this value immediately after each execution of the plan baseline. Therefore, the plan baseline may have been executed more recently than this value indicates.
    
    Parameters:
    
    timeLastExecuted - the value to set
    
    Returns:
    
    this builder
  - enabled
```
public SqlPlanBaseline.Builder enabled(SqlPlanBaseline.Enabled enabled)
```
    Indicates whether the plan baseline is enabled (YES) or disabled (NO).
    
    Parameters:
    
    enabled - the value to set
    
    Returns:
    
    this builder
  - accepted
```
public SqlPlanBaseline.Builder accepted(SqlPlanBaseline.Accepted accepted)
```
    Indicates whether the plan baseline is accepted (YES) or not (NO).
    
    Parameters:
    
    accepted - the value to set
    
    Returns:
    
    this builder
  - fixed
```
public SqlPlanBaseline.Builder fixed(SqlPlanBaseline.Fixed fixed)
```
    Indicates whether the plan baseline is fixed (YES) or not (NO).
    
    Parameters:
    
    fixed - the value to set
    
    Returns:
    
    this builder
  - reproduced
```
public SqlPlanBaseline.Builder reproduced(SqlPlanBaseline.Reproduced reproduced)
```
    Indicates whether the optimizer was able to reproduce the plan (YES) or not (NO). The value is set to YES when a plan is initially added to the plan baseline.
    
    Parameters:
    
    reproduced - the value to set
    
    Returns:
    
    this builder
  - autoPurge
```
public SqlPlanBaseline.Builder autoPurge(SqlPlanBaseline.AutoPurge autoPurge)
```
    Indicates whether the plan baseline is auto-purged (YES) or not (NO).
    
    Parameters:
    
    autoPurge - the value to set
    
    Returns:
    
    this builder
  - adaptive
```
public SqlPlanBaseline.Builder adaptive(SqlPlanBaseline.Adaptive adaptive)
```
    Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.
    
    When a new adaptive plan is found for a SQL statement that has an existing SQL plan baseline, that new plan will be added to the SQL plan baseline as an unaccepted plan, and the ADAPTIVE property will be marked YES. When this new plan is verified (either manually or via the auto evolve task), the plan will be test executed and the final plan determined at execution will become an accepted plan if its performance is better than the existing plan baseline. At this point, the value of the ADAPTIVE property is set to NO since the plan is no longer adaptive, but resolved.
    
    Parameters:
    
    adaptive - the value to set
    
    Returns:
    
    this builder
  - module
```
public SqlPlanBaseline.Builder module(String module)
```
    The application module name.
    
    Parameters:
    
    module - the value to set
    
    Returns:
    
    this builder
  - action
```
public SqlPlanBaseline.Builder action(String action)
```
    The application action.
    
    Parameters:
    
    action - the value to set
    
    Returns:
    
    this builder
  - executionPlan
```
public SqlPlanBaseline.Builder executionPlan(String executionPlan)
```
    The execution plan for the SQL statement.
    
    Parameters:
    
    executionPlan - the value to set
    
    Returns:
    
    this builder
  - build
```
public SqlPlanBaseline build()
```
  - copy
```
public SqlPlanBaseline.Builder copy(SqlPlanBaseline model)
```

Class SqlPlanBaseline.Builder

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

Builder

Method Detail

planName

sqlHandle

sqlText

origin

timeCreated

timeLastModified

timeLastExecuted

enabled

accepted

fixed

reproduced

autoPurge

adaptive

module

action

executionPlan

build

copy