java.lang.Object
- com.oracle.bmc.http.internal.BaseSyncClient
- - com.oracle.bmc.databasemanagement.SqlTuningClient

All Implemented Interfaces:: SqlTuning, AutoCloseable

@Generated(value="OracleSDKGenerator",
           comments="API Version: 20201101")
public class SqlTuningClient
extends BaseSyncClient
implements SqlTuning

Nested Class Summary

Nested Classes
Modifier and Type Class Description

static class SqlTuningClient.Builder
Builder class for this client.

Field Summary

Fields
Modifier and Type	Field	Description
`String`	`clientCommonLibraryVersion`	Compatible SDK version, provided by the codegen.
`Optional<String>`	`minimumClientCommonLibraryVersionFromClient`	Minimum compatible SDK version, maybe provided by the codegen.
`static Service`	`SERVICE`	Service instance for SqlTuning.

Constructor Summary

Constructors
Constructor	Description
`SqlTuningClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory)`	Deprecated. Use the `builder` instead.
`SqlTuningClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, List<ClientConfigurator> additionalClientConfigurators)`	Deprecated. Use the `builder` instead.
`SqlTuningClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, List<ClientConfigurator> additionalClientConfigurators, String endpoint)`	Deprecated. Use the `builder` instead.
`SqlTuningClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator, RequestSignerFactory defaultRequestSignerFactory, Map<SigningStrategy,RequestSignerFactory> signingStrategyRequestSignerFactories, List<ClientConfigurator> additionalClientConfigurators, String endpoint)`	Deprecated. Use the `builder` instead.
`SqlTuningClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider)`	Deprecated. Use the `builder` instead.
`SqlTuningClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration)`	Deprecated. Use the `builder` instead.
`SqlTuningClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider, ClientConfiguration configuration, ClientConfigurator clientConfigurator)`	Deprecated. Use the `builder` instead.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`static SqlTuningClient.Builder`	`builder()`	Create a builder for this client.
`CloneSqlTuningTaskResponse`	`cloneSqlTuningTask(CloneSqlTuningTaskRequest request)`	Clones and runs a SQL tuning task in the database.
`void`	`close()`
`CreateSqlTuningSetResponse`	`createSqlTuningSet(CreateSqlTuningSetRequest request)`	Creates an empty Sql tuning set within the Managed Database specified by managedDatabaseId.
`DropSqlsInSqlTuningSetResponse`	`dropSqlsInSqlTuningSet(DropSqlsInSqlTuningSetRequest request)`	Deletes the Sqls in the specified Sql tuning set that matches the filter criteria provided in the basicFilter.
`DropSqlTuningSetResponse`	`dropSqlTuningSet(DropSqlTuningSetRequest request)`	Drops the Sql tuning set specified by sqlTuningSet within the Managed Database specified by managedDatabaseId.
`DropSqlTuningTaskResponse`	`dropSqlTuningTask(DropSqlTuningTaskRequest request)`	Drops a SQL tuning task and its related results from the database.
`void`	`enableDualStackEndpoints(boolean enableDualStackEndpoints)`	This method should be used to enable or disable the use of dual-stack endpoints.
`FetchSqlTuningSetResponse`	`fetchSqlTuningSet(FetchSqlTuningSetRequest request)`	Fetch the details of Sql statements in the Sql tuning set specified by name, owner and optional filter parameters.
`String`	`getClientCommonLibraryVersion()`
`protected ClientConfigurator`	`getDefaultConfigurator()`
`String`	`getEndpoint()`	Get the endpoint of the client.
`GetExecutionPlanStatsComparisionResponse`	`getExecutionPlanStatsComparision(GetExecutionPlanStatsComparisionRequest request)`	Retrieves a comparison of the existing SQL execution plan and a new plan.
`Optional<String>`	`getMinimumClientCommonLibraryVersionFromClient()`
`Map<String,Boolean>`	`getOptionsMap()`	Return an immutable snapshot representing the current options set for this client.
`SqlTuningPaginators`	`getPaginators()`	Gets the pre-configured paginators available for list operations in this service which may return multiple pages of data.
`String`	`getResolvedEndpoint(Map<String,Object> requiredParametersMap)`	Returns the endpoint after filling in the current options, as determined by `BaseClient.getOptionsMap()`, and then filling in the required parameters in requiredParametersMap into the placeholders in the endpoint.
`GetSqlExecutionPlanResponse`	`getSqlExecutionPlan(GetSqlExecutionPlanRequest request)`	Retrieves a SQL execution plan for the SQL being tuned.
`GetSqlTuningAdvisorTaskSummaryReportResponse`	`getSqlTuningAdvisorTaskSummaryReport(GetSqlTuningAdvisorTaskSummaryReportRequest request)`	Gets the summary report for the specified SQL Tuning Advisor task.
`ListSqlTuningAdvisorTaskFindingsResponse`	`listSqlTuningAdvisorTaskFindings(ListSqlTuningAdvisorTaskFindingsRequest request)`	Gets an array of the details of the findings that match specific filters.
`ListSqlTuningAdvisorTaskRecommendationsResponse`	`listSqlTuningAdvisorTaskRecommendations(ListSqlTuningAdvisorTaskRecommendationsRequest request)`	Gets the findings and possible actions for a given object in a SQL tuning task.
`ListSqlTuningAdvisorTasksResponse`	`listSqlTuningAdvisorTasks(ListSqlTuningAdvisorTasksRequest request)`	Lists the SQL Tuning Advisor tasks for the specified Managed Database.
`ListSqlTuningSetsResponse`	`listSqlTuningSets(ListSqlTuningSetsRequest request)`	Lists the SQL tuning sets for the specified Managed Database.
`LoadSqlTuningSetResponse`	`loadSqlTuningSet(LoadSqlTuningSetRequest request)`	Load Sql statements into the Sql tuning set specified by name and optional filter parameters within the Managed Database specified by managedDatabaseId.
`void`	`refreshClient()`	Rebuild the backing `HttpClient`.
`SaveSqlTuningSetAsResponse`	`saveSqlTuningSetAs(SaveSqlTuningSetAsRequest request)`	Saves the specified list of Sqls statements into another new Sql tuning set or loads into an existing Sql tuning set’.
`void`	`setEndpoint(String endpoint)`
`void`	`setRegion(Region region)`	Sets the region to call (ex, Region.US_PHOENIX_1).
`void`	`setRegion(String regionId)`	Sets the region to call (ex, ‘us-phoenix-1’).
`StartSqlTuningTaskResponse`	`startSqlTuningTask(StartSqlTuningTaskRequest request)`	Starts a SQL tuning task for a given set of SQL statements from the active session history top SQL statements.
`void`	`useRealmSpecificEndpointTemplate(boolean useOfRealmSpecificEndpointTemplateEnabled)`	This method should be used to enable or disable the use of realm-specific endpoint template.
`ValidateBasicFilterResponse`	`validateBasicFilter(ValidateBasicFilterRequest request)`	Executes a SQL query to check whether user entered basic filter criteria is valid or not.

Methods inherited from class com.oracle.bmc.http.internal.BaseSyncClient
clientCall

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

Methods inherited from interface java.lang.AutoCloseable
close

Methods inherited from interface com.oracle.bmc.databasemanagement.SqlTuning
getEndpoint, refreshClient, setEndpoint, useRealmSpecificEndpointTemplate

- Field Detail
  - SERVICE
```
public static final Service SERVICE
```
    Service instance for SqlTuning.
  - clientCommonLibraryVersion
```
public final String clientCommonLibraryVersion
```
    Compatible SDK version, provided by the codegen.
  - minimumClientCommonLibraryVersionFromClient
```
public final Optional<String> minimumClientCommonLibraryVersionFromClient
```
    Minimum compatible SDK version, maybe provided by the codegen.
- Constructor Detail
  - SqlTuningClient
```
@Deprecated
public SqlTuningClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider)
```
    Deprecated.
    Use the builder instead.
    
    Create a new client instance.
    
    Parameters:
    
    authenticationDetailsProvider - The authentication details (see SqlTuningClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider))
  - SqlTuningClient
```
@Deprecated
public SqlTuningClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider,
                       ClientConfiguration configuration)
```
    Deprecated.
    Use the builder instead.
    
    Create a new client instance.
    
    Parameters:
    
    authenticationDetailsProvider - The authentication details (see SqlTuningClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider))
    
    configuration - ClientBuilderBase.configuration
  - SqlTuningClient
```
@Deprecated
public SqlTuningClient(BasicAuthenticationDetailsProvider authenticationDetailsProvider,
                       ClientConfiguration configuration,
                       ClientConfigurator clientConfigurator)
```
    Deprecated.
    Use the builder instead.
    
    Create a new client instance.
    
    Parameters:
    
    authenticationDetailsProvider - The authentication details (see SqlTuningClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider))
    
    configuration - ClientBuilderBase.configuration
    
    clientConfigurator - ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
  - SqlTuningClient
```
@Deprecated
public SqlTuningClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider,
                       ClientConfiguration configuration,
                       ClientConfigurator clientConfigurator,
                       RequestSignerFactory defaultRequestSignerFactory)
```
    Deprecated.
    Use the builder instead.
    
    Create a new client instance.
    
    Parameters:
    
    authenticationDetailsProvider - The authentication details (see SqlTuningClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider))
    
    configuration - ClientBuilderBase.configuration
    
    clientConfigurator - ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
    
    defaultRequestSignerFactory - ClientBuilderBase.requestSignerFactory
  - SqlTuningClient
```
@Deprecated
public SqlTuningClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider,
                       ClientConfiguration configuration,
                       ClientConfigurator clientConfigurator,
                       RequestSignerFactory defaultRequestSignerFactory,
                       List<ClientConfigurator> additionalClientConfigurators)
```
    Deprecated.
    Use the builder instead.
    
    Create a new client instance.
    
    Parameters:
    
    authenticationDetailsProvider - The authentication details (see SqlTuningClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider))
    
    configuration - ClientBuilderBase.configuration
    
    clientConfigurator - ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
    
    defaultRequestSignerFactory - ClientBuilderBase.requestSignerFactory
    
    additionalClientConfigurators - ClientBuilderBase.additionalClientConfigurators
  - SqlTuningClient
```
@Deprecated
public SqlTuningClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider,
                       ClientConfiguration configuration,
                       ClientConfigurator clientConfigurator,
                       RequestSignerFactory defaultRequestSignerFactory,
                       List<ClientConfigurator> additionalClientConfigurators,
                       String endpoint)
```
    Deprecated.
    Use the builder instead.
    
    Create a new client instance.
    
    Parameters:
    
    authenticationDetailsProvider - The authentication details (see SqlTuningClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider))
    
    configuration - ClientBuilderBase.configuration
    
    clientConfigurator - ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
    
    defaultRequestSignerFactory - ClientBuilderBase.requestSignerFactory
    
    additionalClientConfigurators - ClientBuilderBase.additionalClientConfigurators
    
    endpoint - ClientBuilderBase.endpoint(java.lang.String)
  - SqlTuningClient
```
@Deprecated
public SqlTuningClient(AbstractAuthenticationDetailsProvider authenticationDetailsProvider,
                       ClientConfiguration configuration,
                       ClientConfigurator clientConfigurator,
                       RequestSignerFactory defaultRequestSignerFactory,
                       Map<SigningStrategy,RequestSignerFactory> signingStrategyRequestSignerFactories,
                       List<ClientConfigurator> additionalClientConfigurators,
                       String endpoint)
```
    Deprecated.
    Use the builder instead.
    
    Create a new client instance.
    
    Parameters:
    
    authenticationDetailsProvider - The authentication details (see SqlTuningClient.Builder.build(com.oracle.bmc.auth.AbstractAuthenticationDetailsProvider))
    
    configuration - ClientBuilderBase.configuration
    
    clientConfigurator - ClientBuilderBase.clientConfigurator(com.oracle.bmc.http.ClientConfigurator)
    
    defaultRequestSignerFactory - ClientBuilderBase.requestSignerFactory
    
    additionalClientConfigurators - ClientBuilderBase.additionalClientConfigurators
    
    endpoint - ClientBuilderBase.endpoint(java.lang.String)
    
    signingStrategyRequestSignerFactories - ClientBuilderBase.signingStrategyRequestSignerFactories
- Method Detail
  - builder
```
public static SqlTuningClient.Builder builder()
```
    Create a builder for this client.
    
    Returns:
    
    builder
  - setRegion
```
public void setRegion(Region region)
```
    Description copied from interface: SqlTuning
    
    Sets the region to call (ex, Region.US_PHOENIX_1).
    Note, this will call setEndpoint after resolving the endpoint. If the service is not available in this Region, however, an IllegalArgumentException will be raised.
    
    Specified by:
    
    setRegion in interface SqlTuning
    
    Parameters:
    
    region - The region of the service.
  - setRegion
```
public void setRegion(String regionId)
```
    Description copied from interface: SqlTuning
    
    Sets the region to call (ex, ‘us-phoenix-1’).
    Note, this will first try to map the region ID to a known Region and call setRegion.
    If no known Region could be determined, it will create an endpoint based on the default endpoint format (Region.formatDefaultRegionEndpoint(Service, String) and then call setEndpoint.
    
    Specified by:
    
    setRegion in interface SqlTuning
    
    Parameters:
    
    regionId - The public region ID.
  - cloneSqlTuningTask
```
public CloneSqlTuningTaskResponse cloneSqlTuningTask(CloneSqlTuningTaskRequest request)
```
    Description copied from interface: SqlTuning
    
    Clones and runs a SQL tuning task in the database.
    
    Specified by:
    
    cloneSqlTuningTask in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - createSqlTuningSet
```
public CreateSqlTuningSetResponse createSqlTuningSet(CreateSqlTuningSetRequest request)
```
    Description copied from interface: SqlTuning
    
    Creates an empty Sql tuning set within the Managed Database specified by managedDatabaseId.
    
    Specified by:
    
    createSqlTuningSet in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - dropSqlTuningSet
```
public DropSqlTuningSetResponse dropSqlTuningSet(DropSqlTuningSetRequest request)
```
    Description copied from interface: SqlTuning
    
    Drops the Sql tuning set specified by sqlTuningSet within the Managed Database specified by managedDatabaseId.
    
    Specified by:
    
    dropSqlTuningSet in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - dropSqlTuningTask
```
public DropSqlTuningTaskResponse dropSqlTuningTask(DropSqlTuningTaskRequest request)
```
    Description copied from interface: SqlTuning
    
    Drops a SQL tuning task and its related results from the database.
    
    Specified by:
    
    dropSqlTuningTask in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - dropSqlsInSqlTuningSet
```
public DropSqlsInSqlTuningSetResponse dropSqlsInSqlTuningSet(DropSqlsInSqlTuningSetRequest request)
```
    Description copied from interface: SqlTuning
    
    Deletes the Sqls in the specified Sql tuning set that matches the filter criteria provided in the basicFilter.
    If basicFilter criteria is not provided, then entire Sqls in the Sql tuning set is deleted.
    
    Specified by:
    
    dropSqlsInSqlTuningSet in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - fetchSqlTuningSet
```
public FetchSqlTuningSetResponse fetchSqlTuningSet(FetchSqlTuningSetRequest request)
```
    Description copied from interface: SqlTuning
    
    Fetch the details of Sql statements in the Sql tuning set specified by name, owner and optional filter parameters.
    
    Specified by:
    
    fetchSqlTuningSet in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - getExecutionPlanStatsComparision
```
public GetExecutionPlanStatsComparisionResponse getExecutionPlanStatsComparision(GetExecutionPlanStatsComparisionRequest request)
```
    Description copied from interface: SqlTuning
    
    Retrieves a comparison of the existing SQL execution plan and a new plan.
    A SQL tuning task may suggest a new execution plan for a SQL, and this API retrieves the comparison report of the statistics of the two plans.
    
    Specified by:
    
    getExecutionPlanStatsComparision in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - getSqlExecutionPlan
```
public GetSqlExecutionPlanResponse getSqlExecutionPlan(GetSqlExecutionPlanRequest request)
```
    Description copied from interface: SqlTuning
    
    Retrieves a SQL execution plan for the SQL being tuned.
    
    Specified by:
    
    getSqlExecutionPlan in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - getSqlTuningAdvisorTaskSummaryReport
```
public GetSqlTuningAdvisorTaskSummaryReportResponse getSqlTuningAdvisorTaskSummaryReport(GetSqlTuningAdvisorTaskSummaryReportRequest request)
```
    Description copied from interface: SqlTuning
    
    Gets the summary report for the specified SQL Tuning Advisor task.
    
    Specified by:
    
    getSqlTuningAdvisorTaskSummaryReport in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - listSqlTuningAdvisorTaskFindings
```
public ListSqlTuningAdvisorTaskFindingsResponse listSqlTuningAdvisorTaskFindings(ListSqlTuningAdvisorTaskFindingsRequest request)
```
    Description copied from interface: SqlTuning
    
    Gets an array of the details of the findings that match specific filters.
    
    Specified by:
    
    listSqlTuningAdvisorTaskFindings in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - listSqlTuningAdvisorTaskRecommendations
```
public ListSqlTuningAdvisorTaskRecommendationsResponse listSqlTuningAdvisorTaskRecommendations(ListSqlTuningAdvisorTaskRecommendationsRequest request)
```
    Description copied from interface: SqlTuning
    
    Gets the findings and possible actions for a given object in a SQL tuning task.
    The task ID and object ID are used to retrieve the findings and recommendations.
    
    Specified by:
    
    listSqlTuningAdvisorTaskRecommendations in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - listSqlTuningAdvisorTasks
```
public ListSqlTuningAdvisorTasksResponse listSqlTuningAdvisorTasks(ListSqlTuningAdvisorTasksRequest request)
```
    Description copied from interface: SqlTuning
    
    Lists the SQL Tuning Advisor tasks for the specified Managed Database.
    
    Specified by:
    
    listSqlTuningAdvisorTasks in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - listSqlTuningSets
```
public ListSqlTuningSetsResponse listSqlTuningSets(ListSqlTuningSetsRequest request)
```
    Description copied from interface: SqlTuning
    
    Lists the SQL tuning sets for the specified Managed Database.
    
    Specified by:
    
    listSqlTuningSets in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - loadSqlTuningSet
```
public LoadSqlTuningSetResponse loadSqlTuningSet(LoadSqlTuningSetRequest request)
```
    Description copied from interface: SqlTuning
    
    Load Sql statements into the Sql tuning set specified by name and optional filter parameters within the Managed Database specified by managedDatabaseId.
    
    Specified by:
    
    loadSqlTuningSet in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - saveSqlTuningSetAs
```
public SaveSqlTuningSetAsResponse saveSqlTuningSetAs(SaveSqlTuningSetAsRequest request)
```
    Description copied from interface: SqlTuning
    
    Saves the specified list of Sqls statements into another new Sql tuning set or loads into an existing Sql tuning set’.
    
    Specified by:
    
    saveSqlTuningSetAs in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - startSqlTuningTask
```
public StartSqlTuningTaskResponse startSqlTuningTask(StartSqlTuningTaskRequest request)
```
    Description copied from interface: SqlTuning
    
    Starts a SQL tuning task for a given set of SQL statements from the active session history top SQL statements.
    
    Specified by:
    
    startSqlTuningTask in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - validateBasicFilter
```
public ValidateBasicFilterResponse validateBasicFilter(ValidateBasicFilterRequest request)
```
    Description copied from interface: SqlTuning
    
    Executes a SQL query to check whether user entered basic filter criteria is valid or not.
    
    Specified by:
    
    validateBasicFilter in interface SqlTuning
    
    Parameters:
    
    request - The request object containing the details to send
    
    Returns:
    
    A response object containing details about the completed operation
  - getPaginators
```
public SqlTuningPaginators getPaginators()
```
    Description copied from interface: SqlTuning
    
    Gets the pre-configured paginators available for list operations in this service which may return multiple pages of data.
    These paginators provide an Iterable interface so that service responses, or resources/records, can be iterated through without having to manually deal with pagination and page tokens.
    
    Specified by:
    
    getPaginators in interface SqlTuning
    
    Returns:
    
    The service paginators.
  - getDefaultConfigurator
```
protected ClientConfigurator getDefaultConfigurator()
```
  - enableDualStackEndpoints
```
public void enableDualStackEndpoints(boolean enableDualStackEndpoints)
```
    This method should be used to enable or disable the use of dual-stack endpoints.
    The default value is false i.e. dual-stack endpoints are disabled by default.
    
    Parameters:
    
    enableDualStackEndpoints - This flag can be set to true or false to enable or disable the use of dual-stack endpoints respectively
  - getOptionsMap
```
public Map<String,Boolean> getOptionsMap()
```
    Return an immutable snapshot representing the current options set for this client.
    
    Returns:
    
    immutable snapshot representing the current options set for this client
  - getResolvedEndpoint
```
public String getResolvedEndpoint(Map<String,Object> requiredParametersMap)
```
    Returns the endpoint after filling in the current options, as determined by BaseClient.getOptionsMap(), and then filling in the required parameters in requiredParametersMap into the placeholders in the endpoint.
    
    Parameters:
    
    requiredParametersMap - the map from required parameter name to their values
    
    Returns:
    
    resolved endpoint, with all options and placeholders filled in
  - useRealmSpecificEndpointTemplate
```
public void useRealmSpecificEndpointTemplate(boolean useOfRealmSpecificEndpointTemplateEnabled)
```
    This method should be used to enable or disable the use of realm-specific endpoint template.
    The default value is null. To enable the use of endpoint template defined for the realm in use, set the flag to true To disable the use of endpoint template defined for the realm in use, set the flag to false
    
    Parameters:
    
    useOfRealmSpecificEndpointTemplateEnabled - This flag can be set to true or false to enable or disable the use of realm-specific endpoint template respectively
  - setEndpoint
```
public final void setEndpoint(String endpoint)
```
  - getEndpoint
```
public final String getEndpoint()
```
    Get the endpoint of the client.
    Note that the endpoint may be parameterized and contain placeholders and options. The region subdomain and realm domain will have been properly replaced already if the endpoint was selected using a Region.
    Examples of endpoints this may return:
    
    Unparameterized endpoints
    https://identity.us-phoenix-1.oci.oraclecloud.com https://identity.us-ashburn-1.oci.oraclecloud.com https://test-namespace.objectstorage.us-ashburn-1.oci.customer-oci.com
    
    Parameterized endpoints with placeholders
    https://{namespaceName+Dot}objectstorage.us-phoenix-1.oci.customer-oci.com https://{namespaceName+Dot}objectstorage.us-ashburn-1.oci.customer-oci.com
    
    Parameterized endpoints with options
    https://{dualStack?ds.:}identity.us-phoenix-1.oci.oraclecloud.com https://{dualStack?ds.:}identity.us-ashburn-1.oci.oraclecloud.com
    
    Parameterized endpoints with placeholders and options
    https://{namespaceName+Dot}{dualStack?ds.:}objectstorage.us-phoenix-1.oci.customer-oci.com https://{namespaceName+Dot}{dualStack?ds.:}objectstorage.us-ashburn-1.oci.customer-oci.com
    
    To get the actual endpoint for a parameterized request, you can use BaseClient.getResolvedEndpoint(Map) or ParameterizedEndpointUtil.getEndpointWithPopulatedServiceParameters(String, Map, Map).
    Returns:
    
    the endpoint being used by the client
  - refreshClient
```
public final void refreshClient()
```
    Rebuild the backing HttpClient.
    This will call ClientConfigurators again, and can be used to e.g. refresh the SSL certificate.
  - close
```
public final void close()
```
    Specified by:
    
    close in interface AutoCloseable
  - getClientCommonLibraryVersion
```
public String getClientCommonLibraryVersion()
```
  - getMinimumClientCommonLibraryVersionFromClient
```
public Optional<String> getMinimumClientCommonLibraryVersionFromClient()
```

Class SqlTuningClient

Nested Class Summary

Field Summary

Constructor Summary

Method Summary

Methods inherited from class com.oracle.bmc.http.internal.BaseSyncClient

Methods inherited from class java.lang.Object

Methods inherited from interface java.lang.AutoCloseable

Methods inherited from interface com.oracle.bmc.databasemanagement.SqlTuning

Field Detail

SERVICE

clientCommonLibraryVersion

minimumClientCommonLibraryVersionFromClient

Constructor Detail

SqlTuningClient

SqlTuningClient

SqlTuningClient

SqlTuningClient

SqlTuningClient

SqlTuningClient

SqlTuningClient

Method Detail

builder

setRegion

setRegion

cloneSqlTuningTask

createSqlTuningSet

dropSqlTuningSet

dropSqlTuningTask

dropSqlsInSqlTuningSet

fetchSqlTuningSet

getExecutionPlanStatsComparision

getSqlExecutionPlan

getSqlTuningAdvisorTaskSummaryReport

listSqlTuningAdvisorTaskFindings

listSqlTuningAdvisorTaskRecommendations

listSqlTuningAdvisorTasks

listSqlTuningSets

loadSqlTuningSet

saveSqlTuningSetAs

startSqlTuningTask

validateBasicFilter

getPaginators

getDefaultConfigurator

enableDualStackEndpoints

getOptionsMap

getResolvedEndpoint

useRealmSpecificEndpointTemplate

setEndpoint

getEndpoint

refreshClient

close

getClientCommonLibraryVersion

getMinimumClientCommonLibraryVersionFromClient