com.oracle.bmc.databasemanagement.requests

Class ListSqlTuningAdvisorTaskFindingsRequest.Builder

java.lang.Object

com.oracle.bmc.databasemanagement.requests.ListSqlTuningAdvisorTaskFindingsRequest.Builder

All Implemented Interfaces:

BmcRequest.Builder<ListSqlTuningAdvisorTaskFindingsRequest,Void>

Enclosing class:

ListSqlTuningAdvisorTaskFindingsRequest

public static class ListSqlTuningAdvisorTaskFindingsRequest.Builder
extends Object
implements BmcRequest.Builder<ListSqlTuningAdvisorTaskFindingsRequest,Void>

Constructor Summary

Constructors

Constructor and Description
Builder()

Method Summary

Modifier and Type	Method and Description
ListSqlTuningAdvisorTaskFindingsRequest.Builder	beginExecId(Long beginExecId) The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task.
ListSqlTuningAdvisorTaskFindingsRequest	build() Build the instance of ListSqlTuningAdvisorTaskFindingsRequest as configured by this builder
ListSqlTuningAdvisorTaskFindingsRequest	buildWithoutInvocationCallback() Build the instance of ListSqlTuningAdvisorTaskFindingsRequest as configured by this builder
ListSqlTuningAdvisorTaskFindingsRequest.Builder	copy(ListSqlTuningAdvisorTaskFindingsRequest o) Copy method to populate the builder with values from the given instance.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	endExecId(Long endExecId) The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	findingFilter(ListSqlTuningAdvisorTaskFindingsRequest.FindingFilter findingFilter) The filter used to display specific findings in the report.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	indexHashFilter(String indexHashFilter) The hash value of the index table name.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	invocationCallback(com.oracle.bmc.http.client.RequestInterceptor invocationCallback) Set the invocation callback for the request to be built.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	limit(Integer limit) The maximum number of records returned in the paginated response.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	managedDatabaseId(String managedDatabaseId) The OCID of the Managed Database.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	opcNamedCredentialId(String opcNamedCredentialId) The OCID of the Named Credential.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	opcRequestId(String opcRequestId) The client request ID for tracing.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	page(String page) The page token representing the page from where the next set of paginated results are retrieved.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	retryConfiguration(RetryConfiguration retryConfiguration) Set the retry configuration for the request to be built.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	searchPeriod(ListSqlTuningAdvisorTaskFindingsRequest.SearchPeriod searchPeriod) The search period during which the API will search for begin and end exec id, if not supplied.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	sortBy(ListSqlTuningAdvisorTaskFindingsRequest.SortBy sortBy) The possible sortBy values of an object’s recommendations.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	sortOrder(SortOrders sortOrder) The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	sqlTuningAdvisorTaskId(Long sqlTuningAdvisorTaskId) The SQL tuning task identifier.
ListSqlTuningAdvisorTaskFindingsRequest.Builder	statsHashFilter(String statsHashFilter) The hash value of the object for the statistic finding search.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.oracle.bmc.requests.BmcRequest.Builder

body$

Constructor Detail

Builder

public Builder()

Method Detail

managedDatabaseId

public ListSqlTuningAdvisorTaskFindingsRequest.Builder managedDatabaseId(String managedDatabaseId)

The OCID of the Managed Database.

Parameters:

managedDatabaseId - the value to set

Returns:

this builder instance

sqlTuningAdvisorTaskId

public ListSqlTuningAdvisorTaskFindingsRequest.Builder sqlTuningAdvisorTaskId(Long sqlTuningAdvisorTaskId)

The SQL tuning task identifier. This is not the OCID.

Parameters:

sqlTuningAdvisorTaskId - the value to set

Returns:

this builder instance

beginExecId

public ListSqlTuningAdvisorTaskFindingsRequest.Builder beginExecId(Long beginExecId)

The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task.

Parameters:

beginExecId - the value to set

Returns:

this builder instance

endExecId

public ListSqlTuningAdvisorTaskFindingsRequest.Builder endExecId(Long endExecId)

The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task.

Parameters:

endExecId - the value to set

Returns:

this builder instance

searchPeriod

public ListSqlTuningAdvisorTaskFindingsRequest.Builder searchPeriod(ListSqlTuningAdvisorTaskFindingsRequest.SearchPeriod searchPeriod)

The search period during which the API will search for begin and end exec id, if not supplied. Unused if beginExecId and endExecId optional query params are both supplied.

Parameters:

searchPeriod - the value to set

Returns:

this builder instance

findingFilter

public ListSqlTuningAdvisorTaskFindingsRequest.Builder findingFilter(ListSqlTuningAdvisorTaskFindingsRequest.FindingFilter findingFilter)

The filter used to display specific findings in the report.

Parameters:

findingFilter - the value to set

Returns:

this builder instance

statsHashFilter

public ListSqlTuningAdvisorTaskFindingsRequest.Builder statsHashFilter(String statsHashFilter)

The hash value of the object for the statistic finding search.

Parameters:

statsHashFilter - the value to set

Returns:

this builder instance

indexHashFilter

public ListSqlTuningAdvisorTaskFindingsRequest.Builder indexHashFilter(String indexHashFilter)

The hash value of the index table name.

Parameters:

indexHashFilter - the value to set

Returns:

this builder instance

sortBy

public ListSqlTuningAdvisorTaskFindingsRequest.Builder sortBy(ListSqlTuningAdvisorTaskFindingsRequest.SortBy sortBy)

The possible sortBy values of an object’s recommendations.

Parameters:

sortBy - the value to set

Returns:

this builder instance

sortOrder

public ListSqlTuningAdvisorTaskFindingsRequest.Builder sortOrder(SortOrders sortOrder)

The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Descending order is the default order.

Parameters:

sortOrder - the value to set

Returns:

this builder instance

page

public ListSqlTuningAdvisorTaskFindingsRequest.Builder page(String page)

The page token representing the page from where the next set of paginated results are retrieved. This is usually retrieved from a previous list call.

Parameters:

page - the value to set

Returns:

this builder instance

limit

public ListSqlTuningAdvisorTaskFindingsRequest.Builder limit(Integer limit)

The maximum number of records returned in the paginated response.

Parameters:

limit - the value to set

Returns:

this builder instance

opcRequestId

public ListSqlTuningAdvisorTaskFindingsRequest.Builder opcRequestId(String opcRequestId)

The client request ID for tracing.

Parameters:

opcRequestId - the value to set

Returns:

this builder instance

opcNamedCredentialId

public ListSqlTuningAdvisorTaskFindingsRequest.Builder opcNamedCredentialId(String opcNamedCredentialId)

The OCID of the Named Credential.

Parameters:

opcNamedCredentialId - the value to set

Returns:

this builder instance

invocationCallback

public ListSqlTuningAdvisorTaskFindingsRequest.Builder invocationCallback(com.oracle.bmc.http.client.RequestInterceptor invocationCallback)

Set the invocation callback for the request to be built.

Parameters:

invocationCallback - the invocation callback to be set for the request

Returns:

this builder instance

retryConfiguration

public ListSqlTuningAdvisorTaskFindingsRequest.Builder retryConfiguration(RetryConfiguration retryConfiguration)

Set the retry configuration for the request to be built.

Parameters:

retryConfiguration - the retry configuration to be used for the request

Returns:

this builder instance

copy

public ListSqlTuningAdvisorTaskFindingsRequest.Builder copy(ListSqlTuningAdvisorTaskFindingsRequest o)

Copy method to populate the builder with values from the given instance.

Specified by:

copy in interface BmcRequest.Builder<ListSqlTuningAdvisorTaskFindingsRequest,Void>

Parameters:

o - other request from which to copy values

Returns:

this builder instance

build

public ListSqlTuningAdvisorTaskFindingsRequest build()

Build the instance of ListSqlTuningAdvisorTaskFindingsRequest as configured by this builder

Note that this method takes calls to invocationCallback(com.oracle.bmc.http.client.RequestInterceptor) into account, while the method buildWithoutInvocationCallback() does not.

This is the preferred method to build an instance.

Specified by:

build in interface BmcRequest.Builder<ListSqlTuningAdvisorTaskFindingsRequest,Void>

Returns:

instance of ListSqlTuningAdvisorTaskFindingsRequest

buildWithoutInvocationCallback

public ListSqlTuningAdvisorTaskFindingsRequest buildWithoutInvocationCallback()

Build the instance of ListSqlTuningAdvisorTaskFindingsRequest as configured by this builder

Note that this method does not take calls to invocationCallback(com.oracle.bmc.http.client.RequestInterceptor) into account, while the method build() does

Returns:

instance of ListSqlTuningAdvisorTaskFindingsRequest