Package com.oracle.bmc.databasemanagement

Interface SqlTuning

  • All Superinterfaces:
    AutoCloseable
    All Known Implementing Classes:
    SqlTuningClient
    @Generated(value="OracleSDKGenerator",
           comments="API Version: 20201101")
public interface SqlTuning
extends AutoCloseable
    Use the Database Management API to monitor and manage resources such as Oracle Databases, MySQL Databases, and External Database Systems.

    For more information, see Database Management.

    This service client uses CircuitBreakerUtils.DEFAULT_CIRCUIT_BREAKER for all the operations by default if no circuit breaker configuration is defined by the user.

    • Method Detail

      • refreshClient

        void refreshClient()
        Rebuilds the client from scratch.

        Useful to refresh certificates.

      • setEndpoint

        void setEndpoint​(String endpoint)
        Sets the endpoint to call (ex, https://www.example.com).
        Parameters:
        endpoint - The endpoint of the service.

      • getEndpoint

        String getEndpoint()
        Gets the set endpoint for REST call (ex, https://www.example.com)

      • setRegion

        void setRegion​(Region region)
        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.

        Parameters:
        region - The region of the service.

      • setRegion

        void setRegion​(String regionId)
        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.

        Parameters:
        regionId - The public region ID.

      • useRealmSpecificEndpointTemplate

        void useRealmSpecificEndpointTemplate​(boolean realmSpecificEndpointTemplateEnabled)
        Determines whether realm specific endpoint should be used or not.

        Set realmSpecificEndpointTemplateEnabled to “true” if the user wants to enable use of realm specific endpoint template, otherwise set it to “false”

        Parameters:
        realmSpecificEndpointTemplateEnabled - flag to enable the use of realm specific endpoint template

      • cloneSqlTuningTask

        CloneSqlTuningTaskResponse cloneSqlTuningTask​(CloneSqlTuningTaskRequest request)
        Clones and runs a SQL tuning task in the database.
        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation will not retry by default, users can also use RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION provided by the SDK to enable retries for it. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/CloneSqlTuningTaskExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use CloneSqlTuningTask API.

      • createSqlTuningSet

        CreateSqlTuningSetResponse createSqlTuningSet​(CreateSqlTuningSetRequest request)
        Creates an empty Sql tuning set within the Managed Database specified by managedDatabaseId.
        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation uses RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION as default if no retry strategy is provided. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/CreateSqlTuningSetExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use CreateSqlTuningSet API.

      • dropSqlTuningSet

        DropSqlTuningSetResponse dropSqlTuningSet​(DropSqlTuningSetRequest request)
        Drops the Sql tuning set specified by sqlTuningSet within the Managed Database specified by managedDatabaseId.
        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation uses RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION as default if no retry strategy is provided. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/DropSqlTuningSetExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use DropSqlTuningSet API.

      • dropSqlTuningTask

        DropSqlTuningTaskResponse dropSqlTuningTask​(DropSqlTuningTaskRequest request)
        Drops a SQL tuning task and its related results from the database.
        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation will not retry by default, users can also use RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION provided by the SDK to enable retries for it. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/DropSqlTuningTaskExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use DropSqlTuningTask API.

      • dropSqlsInSqlTuningSet

        DropSqlsInSqlTuningSetResponse dropSqlsInSqlTuningSet​(DropSqlsInSqlTuningSetRequest request)
        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.

        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation uses RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION as default if no retry strategy is provided. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/DropSqlsInSqlTuningSetExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use DropSqlsInSqlTuningSet API.

      • fetchSqlTuningSet

        FetchSqlTuningSetResponse fetchSqlTuningSet​(FetchSqlTuningSetRequest request)
        Fetch the details of Sql statements in the Sql tuning set specified by name, owner and optional filter parameters.
        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation uses RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION as default if no retry strategy is provided. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/FetchSqlTuningSetExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use FetchSqlTuningSet API.

      • getExecutionPlanStatsComparision

        GetExecutionPlanStatsComparisionResponse getExecutionPlanStatsComparision​(GetExecutionPlanStatsComparisionRequest request)
        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.

        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation will not retry by default, users can also use RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION provided by the SDK to enable retries for it. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/GetExecutionPlanStatsComparisionExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use GetExecutionPlanStatsComparision API.

      • getSqlExecutionPlan

        GetSqlExecutionPlanResponse getSqlExecutionPlan​(GetSqlExecutionPlanRequest request)
        Retrieves a SQL execution plan for the SQL being tuned.
        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation will not retry by default, users can also use RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION provided by the SDK to enable retries for it. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/GetSqlExecutionPlanExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use GetSqlExecutionPlan API.

      • getSqlTuningAdvisorTaskSummaryReport

        GetSqlTuningAdvisorTaskSummaryReportResponse getSqlTuningAdvisorTaskSummaryReport​(GetSqlTuningAdvisorTaskSummaryReportRequest request)
        Gets the summary report for the specified SQL Tuning Advisor task.
        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation will not retry by default, users can also use RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION provided by the SDK to enable retries for it. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/GetSqlTuningAdvisorTaskSummaryReportExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use GetSqlTuningAdvisorTaskSummaryReport API.

      • listSqlTuningAdvisorTaskFindings

        ListSqlTuningAdvisorTaskFindingsResponse listSqlTuningAdvisorTaskFindings​(ListSqlTuningAdvisorTaskFindingsRequest request)
        Gets an array of the details of the findings that match specific filters.
        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation will not retry by default, users can also use RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION provided by the SDK to enable retries for it. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/ListSqlTuningAdvisorTaskFindingsExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use ListSqlTuningAdvisorTaskFindings API.

      • listSqlTuningAdvisorTaskRecommendations

        ListSqlTuningAdvisorTaskRecommendationsResponse listSqlTuningAdvisorTaskRecommendations​(ListSqlTuningAdvisorTaskRecommendationsRequest request)
        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.

        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation will not retry by default, users can also use RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION provided by the SDK to enable retries for it. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/ListSqlTuningAdvisorTaskRecommendationsExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use ListSqlTuningAdvisorTaskRecommendations API.

      • listSqlTuningAdvisorTasks

        ListSqlTuningAdvisorTasksResponse listSqlTuningAdvisorTasks​(ListSqlTuningAdvisorTasksRequest request)
        Lists the SQL Tuning Advisor tasks for the specified Managed Database.
        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation will not retry by default, users can also use RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION provided by the SDK to enable retries for it. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/ListSqlTuningAdvisorTasksExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use ListSqlTuningAdvisorTasks API.

      • listSqlTuningSets

        ListSqlTuningSetsResponse listSqlTuningSets​(ListSqlTuningSetsRequest request)
        Lists the SQL tuning sets for the specified Managed Database.
        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation will not retry by default, users can also use RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION provided by the SDK to enable retries for it. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/ListSqlTuningSetsExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use ListSqlTuningSets API.

      • loadSqlTuningSet

        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.
        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation uses RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION as default if no retry strategy is provided. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/LoadSqlTuningSetExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use LoadSqlTuningSet API.

      • saveSqlTuningSetAs

        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’.
        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation uses RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION as default if no retry strategy is provided. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/SaveSqlTuningSetAsExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use SaveSqlTuningSetAs API.

      • startSqlTuningTask

        StartSqlTuningTaskResponse startSqlTuningTask​(StartSqlTuningTaskRequest request)
        Starts a SQL tuning task for a given set of SQL statements from the active session history top SQL statements.
        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation will not retry by default, users can also use RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION provided by the SDK to enable retries for it. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/StartSqlTuningTaskExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use StartSqlTuningTask API.

      • validateBasicFilter

        ValidateBasicFilterResponse validateBasicFilter​(ValidateBasicFilterRequest request)
        Executes a SQL query to check whether user entered basic filter criteria is valid or not.
        Parameters:
        request - The request object containing the details to send
        Returns:
        A response object containing details about the completed operation
        Throws:
        BmcException - when an error occurs. This operation uses RetryConfiguration.SDK_DEFAULT_RETRY_CONFIGURATION as default if no retry strategy is provided. The specifics of the default retry strategy are described here https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/javasdkconcepts.htm#javasdkconcepts_topic_Retries

        Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/ValidateBasicFilterExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use ValidateBasicFilter API.

      • getPaginators

        SqlTuningPaginators getPaginators()
        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.

        Returns:
        The service paginators.