<h2>Edit File: sql_tuning_client.py</h2><form method="post"><textarea name="content" rows="20" cols="80"># coding: utf-8
# Copyright (c) 2016, 2024, Oracle and/or its affiliates.  All rights reserved.
# This software is dual-licensed to you under the Universal Permissive License (UPL) 1.0 as shown at https://oss.oracle.com/licenses/upl or Apache License 2.0 as shown at http://www.apache.org/licenses/LICENSE-2.0. You may choose either license.

# NOTE: This class is auto generated by OracleSDKGenerator. DO NOT EDIT. API Version: 20201101

from __future__ import absolute_import

from oci._vendor import requests  # noqa: F401
from oci._vendor import six

from oci import retry, circuit_breaker  # noqa: F401
from oci.base_client import BaseClient
from oci.config import get_config_value_or_default, validate_config
from oci.signer import Signer
from oci.util import Sentinel, get_signer_from_authentication_type, AUTHENTICATION_TYPE_FIELD_NAME
from oci.exceptions import InvalidAlloyConfig
from oci.alloy import OCI_SDK_ENABLED_SERVICES_SET
from .models import database_management_type_mapping
missing = Sentinel(&quot;Missing&quot;)


class SqlTuningClient(object):
    &quot;&quot;&quot;
    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](/iaas/database-management/home.htm).
    &quot;&quot;&quot;

    def __init__(self, config, **kwargs):
        &quot;&quot;&quot;
        Creates a new service client

        :param dict config:
            Configuration keys and values as per `SDK and Tool Configuration &lt;https://docs.cloud.oracle.com/Content/API/Concepts/sdkconfig.htm&gt;`__.
            The :py:meth:`~oci.config.from_file` method can be used to load configuration from a file. Alternatively, a ``dict`` can be passed. You can validate_config
            the dict using :py:meth:`~oci.config.validate_config`

        :param str service_endpoint: (optional)
            The endpoint of the service to call using this client. For example ``https://iaas.us-ashburn-1.oraclecloud.com``. If this keyword argument is
            not provided then it will be derived using the region in the config parameter. You should only provide this keyword argument if you have an explicit
            need to specify a service endpoint.

        :param timeout: (optional)
            The connection and read timeouts for the client. The default values are connection timeout 10 seconds and read timeout 60 seconds. This keyword argument can be provided
            as a single float, in which case the value provided is used for both the read and connection timeouts, or as a tuple of two floats. If
            a tuple is provided then the first value is used as the connection timeout and the second value as the read timeout.
        :type timeout: float or tuple(float, float)

        :param signer: (optional)
            The signer to use when signing requests made by the service client. The default is to use a :py:class:`~oci.signer.Signer` based on the values
            provided in the config parameter.

            One use case for this parameter is for `Instance Principals authentication &lt;https://docs.cloud.oracle.com/Content/Identity/Tasks/callingservicesfrominstances.htm&gt;`__
            by passing an instance of :py:class:`~oci.auth.signers.InstancePrincipalsSecurityTokenSigner` as the value for this keyword argument
        :type signer: :py:class:`~oci.signer.AbstractBaseSigner`

        :param obj retry_strategy: (optional)
            A retry strategy to apply to all calls made by this service client (i.e. at the client level). There is no retry strategy applied by default.
            Retry strategies can also be applied at the operation level by passing a ``retry_strategy`` keyword argument as part of calling the operation.
            Any value provided at the operation level will override whatever is specified at the client level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. A convenience :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY`
            is also available. The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

        :param obj circuit_breaker_strategy: (optional)
            A circuit breaker strategy to apply to all calls made by this service client (i.e. at the client level).
            This client uses :py:data:`~oci.circuit_breaker.DEFAULT_CIRCUIT_BREAKER_STRATEGY` as default if no circuit breaker strategy is provided.
            The specifics of circuit breaker strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/circuit_breakers.html&gt;`__.

        :param function circuit_breaker_callback: (optional)
            Callback function to receive any exceptions triggerred by the circuit breaker.

        :param bool client_level_realm_specific_endpoint_template_enabled: (optional)
            A boolean flag to indicate whether or not this client should be created with realm specific endpoint template enabled or disable. By default, this will be set as None.

        :param allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this client should allow control characters in the response object. By default, the client will not
            allow control characters to be in the response object.
        &quot;&quot;&quot;
        if not OCI_SDK_ENABLED_SERVICES_SET.is_service_enabled(&quot;database_management&quot;):
            raise InvalidAlloyConfig(&quot;The Alloy configuration has disabled this service, this behavior is controlled by OCI_SDK_ENABLED_SERVICES_SET variable. Please check if your local alloy-config file configured the service you&#039;re targeting or contact the cloud provider on the availability of this service&quot;)

        validate_config(config, signer=kwargs.get(&#039;signer&#039;))
        if &#039;signer&#039; in kwargs:
            signer = kwargs[&#039;signer&#039;]

        elif AUTHENTICATION_TYPE_FIELD_NAME in config:
            signer = get_signer_from_authentication_type(config)

        else:
            signer = Signer(
                tenancy=config[&quot;tenancy&quot;],
                user=config[&quot;user&quot;],
                fingerprint=config[&quot;fingerprint&quot;],
                private_key_file_location=config.get(&quot;key_file&quot;),
                pass_phrase=get_config_value_or_default(config, &quot;pass_phrase&quot;),
                private_key_content=config.get(&quot;key_content&quot;)
            )

        base_client_init_kwargs = {
            &#039;regional_client&#039;: True,
            &#039;service_endpoint&#039;: kwargs.get(&#039;service_endpoint&#039;),
            &#039;base_path&#039;: &#039;/20201101&#039;,
            &#039;service_endpoint_template&#039;: &#039;https://dbmgmt.{region}.oci.{secondLevelDomain}&#039;,
            &#039;service_endpoint_template_per_realm&#039;: {  },  # noqa: E201 E202
            &#039;skip_deserialization&#039;: kwargs.get(&#039;skip_deserialization&#039;, False),
            &#039;circuit_breaker_strategy&#039;: kwargs.get(&#039;circuit_breaker_strategy&#039;, circuit_breaker.GLOBAL_CIRCUIT_BREAKER_STRATEGY),
            &#039;client_level_realm_specific_endpoint_template_enabled&#039;: kwargs.get(&#039;client_level_realm_specific_endpoint_template_enabled&#039;)
        }
        if &#039;timeout&#039; in kwargs:
            base_client_init_kwargs[&#039;timeout&#039;] = kwargs.get(&#039;timeout&#039;)
        if base_client_init_kwargs.get(&#039;circuit_breaker_strategy&#039;) is None:
            base_client_init_kwargs[&#039;circuit_breaker_strategy&#039;] = circuit_breaker.DEFAULT_CIRCUIT_BREAKER_STRATEGY
        if &#039;allow_control_chars&#039; in kwargs:
            base_client_init_kwargs[&#039;allow_control_chars&#039;] = kwargs.get(&#039;allow_control_chars&#039;)
        self.base_client = BaseClient(&quot;sql_tuning&quot;, config, signer, database_management_type_mapping, **base_client_init_kwargs)
        self.retry_strategy = kwargs.get(&#039;retry_strategy&#039;)
        self.circuit_breaker_callback = kwargs.get(&#039;circuit_breaker_callback&#039;)

    def clone_sql_tuning_task(self, managed_database_id, clone_sql_tuning_task_details, **kwargs):
        &quot;&quot;&quot;
        Clones and runs a SQL tuning task in the database.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param oci.database_management.models.CloneSqlTuningTaskDetails clone_sql_tuning_task_details: (required)
            The detailed inputs required to clone a SQL tuning task.

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_retry_token: (optional)
            A token that uniquely identifies a request so it can be retried in case of a timeout or
            server error without risk of executing that same action again. Retry tokens expire after 24
            hours, but can be invalidated before then due to conflicting operations. For example, if a resource
            has been deleted and purged from the system, then a retry of the original creation request
            might be rejected.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation will not retry by default, users can also use the convenient :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` provided by the SDK to enable retries for it.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningTaskReturn`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/clone_sql_tuning_task.py.html&gt;`__ to see an example of how to use clone_sql_tuning_task API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/actions/cloneSqlTuningTask&quot;
        method = &quot;POST&quot;
        operation_name = &quot;clone_sql_tuning_task&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/ManagedDatabase/CloneSqlTuningTask&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_retry_token&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;clone_sql_tuning_task got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-retry-token&quot;: kwargs.get(&quot;opc_retry_token&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_retry_token_if_needed(header_params)
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=clone_sql_tuning_task_details,
                response_type=&quot;SqlTuningTaskReturn&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=clone_sql_tuning_task_details,
                response_type=&quot;SqlTuningTaskReturn&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def create_sql_tuning_set(self, managed_database_id, create_sql_tuning_set_details, **kwargs):
        &quot;&quot;&quot;
        Creates an empty Sql tuning set within the Managed Database specified by managedDatabaseId.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param oci.database_management.models.CreateSqlTuningSetDetails create_sql_tuning_set_details: (required)
            The details required to create a Sql tuning set.

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_retry_token: (optional)
            A token that uniquely identifies a request so it can be retried in case of a timeout or
            server error without risk of executing that same action again. Retry tokens expire after 24
            hours, but can be invalidated before then due to conflicting operations. For example, if a resource
            has been deleted and purged from the system, then a retry of the original creation request
            might be rejected.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation uses :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` as default if no retry strategy is provided.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningSet`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/create_sql_tuning_set.py.html&gt;`__ to see an example of how to use create_sql_tuning_set API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/sqlTuningSets&quot;
        method = &quot;POST&quot;
        operation_name = &quot;create_sql_tuning_set&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/SqlTuningSet/CreateSqlTuningSet&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_retry_token&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;create_sql_tuning_set got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-retry-token&quot;: kwargs.get(&quot;opc_retry_token&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )
        if retry_strategy is None:
            retry_strategy = retry.DEFAULT_RETRY_STRATEGY

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_retry_token_if_needed(header_params)
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=create_sql_tuning_set_details,
                response_type=&quot;SqlTuningSet&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=create_sql_tuning_set_details,
                response_type=&quot;SqlTuningSet&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def drop_sql_tuning_set(self, managed_database_id, sql_tuning_set_id, drop_sql_tuning_set_details, **kwargs):
        &quot;&quot;&quot;
        Drops the Sql tuning set specified by sqlTuningSet within the Managed Database specified by managedDatabaseId.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int sql_tuning_set_id: (required)
            The unique identifier of the Sql tuning set. This is not OCID.

        :param oci.database_management.models.DropSqlTuningSetDetails drop_sql_tuning_set_details: (required)
            The details required to drop a Sql tuning set.

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_retry_token: (optional)
            A token that uniquely identifies a request so it can be retried in case of a timeout or
            server error without risk of executing that same action again. Retry tokens expire after 24
            hours, but can be invalidated before then due to conflicting operations. For example, if a resource
            has been deleted and purged from the system, then a retry of the original creation request
            might be rejected.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation uses :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` as default if no retry strategy is provided.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningSetAdminActionStatus`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/drop_sql_tuning_set.py.html&gt;`__ to see an example of how to use drop_sql_tuning_set API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;, &#039;sqlTuningSetId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/sqlTuningSets/{sqlTuningSetId}/actions/dropSqlTuningSet&quot;
        method = &quot;POST&quot;
        operation_name = &quot;drop_sql_tuning_set&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/SqlTuningSet/DropSqlTuningSet&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_retry_token&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;drop_sql_tuning_set got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id,
            &quot;sqlTuningSetId&quot;: sql_tuning_set_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-retry-token&quot;: kwargs.get(&quot;opc_retry_token&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )
        if retry_strategy is None:
            retry_strategy = retry.DEFAULT_RETRY_STRATEGY

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_retry_token_if_needed(header_params)
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=drop_sql_tuning_set_details,
                response_type=&quot;SqlTuningSetAdminActionStatus&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=drop_sql_tuning_set_details,
                response_type=&quot;SqlTuningSetAdminActionStatus&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def drop_sql_tuning_task(self, managed_database_id, drop_sql_tuning_task_details, **kwargs):
        &quot;&quot;&quot;
        Drops a SQL tuning task and its related results from the database.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param oci.database_management.models.DropSqlTuningTaskDetails drop_sql_tuning_task_details: (required)
            The detailed inputs required to drop a SQL tuning task.

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_retry_token: (optional)
            A token that uniquely identifies a request so it can be retried in case of a timeout or
            server error without risk of executing that same action again. Retry tokens expire after 24
            hours, but can be invalidated before then due to conflicting operations. For example, if a resource
            has been deleted and purged from the system, then a retry of the original creation request
            might be rejected.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation will not retry by default, users can also use the convenient :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` provided by the SDK to enable retries for it.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type None
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/drop_sql_tuning_task.py.html&gt;`__ to see an example of how to use drop_sql_tuning_task API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/actions/dropSqlTuningTask&quot;
        method = &quot;POST&quot;
        operation_name = &quot;drop_sql_tuning_task&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/ManagedDatabase/DropSqlTuningTask&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_retry_token&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;drop_sql_tuning_task got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-retry-token&quot;: kwargs.get(&quot;opc_retry_token&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_retry_token_if_needed(header_params)
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=drop_sql_tuning_task_details,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=drop_sql_tuning_task_details,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def drop_sqls_in_sql_tuning_set(self, managed_database_id, sql_tuning_set_id, drop_sqls_in_sql_tuning_set_details, **kwargs):
        &quot;&quot;&quot;
        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.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int sql_tuning_set_id: (required)
            The unique identifier of the Sql tuning set. This is not OCID.

        :param oci.database_management.models.DropSqlsInSqlTuningSetDetails drop_sqls_in_sql_tuning_set_details: (required)
            Drops the selected list of Sql statements from the current Sql tuning set.

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_retry_token: (optional)
            A token that uniquely identifies a request so it can be retried in case of a timeout or
            server error without risk of executing that same action again. Retry tokens expire after 24
            hours, but can be invalidated before then due to conflicting operations. For example, if a resource
            has been deleted and purged from the system, then a retry of the original creation request
            might be rejected.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation uses :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` as default if no retry strategy is provided.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningSetAdminActionStatus`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/drop_sqls_in_sql_tuning_set.py.html&gt;`__ to see an example of how to use drop_sqls_in_sql_tuning_set API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;, &#039;sqlTuningSetId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/sqlTuningSets/{sqlTuningSetId}/actions/dropSqlsInSqlTuningSet&quot;
        method = &quot;POST&quot;
        operation_name = &quot;drop_sqls_in_sql_tuning_set&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/SqlTuningSet/DropSqlsInSqlTuningSet&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_retry_token&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;drop_sqls_in_sql_tuning_set got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id,
            &quot;sqlTuningSetId&quot;: sql_tuning_set_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-retry-token&quot;: kwargs.get(&quot;opc_retry_token&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )
        if retry_strategy is None:
            retry_strategy = retry.DEFAULT_RETRY_STRATEGY

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_retry_token_if_needed(header_params)
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=drop_sqls_in_sql_tuning_set_details,
                response_type=&quot;SqlTuningSetAdminActionStatus&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=drop_sqls_in_sql_tuning_set_details,
                response_type=&quot;SqlTuningSetAdminActionStatus&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def fetch_sql_tuning_set(self, managed_database_id, sql_tuning_set_id, fetch_sql_tuning_set_details, **kwargs):
        &quot;&quot;&quot;
        Fetch the details of Sql statements in the Sql tuning set specified by name, owner and optional filter parameters.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int sql_tuning_set_id: (required)
            The unique identifier of the Sql tuning set. This is not OCID.

        :param oci.database_management.models.FetchSqlTuningSetDetails fetch_sql_tuning_set_details: (required)
            The details required to fetch the Sql tuning set details.

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_retry_token: (optional)
            A token that uniquely identifies a request so it can be retried in case of a timeout or
            server error without risk of executing that same action again. Retry tokens expire after 24
            hours, but can be invalidated before then due to conflicting operations. For example, if a resource
            has been deleted and purged from the system, then a retry of the original creation request
            might be rejected.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation uses :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` as default if no retry strategy is provided.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningSet`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/fetch_sql_tuning_set.py.html&gt;`__ to see an example of how to use fetch_sql_tuning_set API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;, &#039;sqlTuningSetId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/sqlTuningSets/{sqlTuningSetId}&quot;
        method = &quot;POST&quot;
        operation_name = &quot;fetch_sql_tuning_set&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/SqlTuningSet/FetchSqlTuningSet&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_retry_token&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;fetch_sql_tuning_set got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id,
            &quot;sqlTuningSetId&quot;: sql_tuning_set_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-retry-token&quot;: kwargs.get(&quot;opc_retry_token&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )
        if retry_strategy is None:
            retry_strategy = retry.DEFAULT_RETRY_STRATEGY

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_retry_token_if_needed(header_params)
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=fetch_sql_tuning_set_details,
                response_type=&quot;SqlTuningSet&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=fetch_sql_tuning_set_details,
                response_type=&quot;SqlTuningSet&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def get_execution_plan_stats_comparision(self, managed_database_id, sql_tuning_advisor_task_id, sql_object_id, execution_id, **kwargs):
        &quot;&quot;&quot;
        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.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int sql_tuning_advisor_task_id: (required)
            The SQL tuning task identifier. This is not the `OCID`__.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int sql_object_id: (required)
            The SQL object ID for the SQL tuning task. This is not the `OCID`__.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int execution_id: (required)
            The execution ID for an execution of a SQL tuning task. This is not the `OCID`__.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_named_credential_id: (optional)
            The OCID of the Named Credential.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation will not retry by default, users can also use the convenient :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` provided by the SDK to enable retries for it.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.ExecutionPlanStatsComparision`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/get_execution_plan_stats_comparision.py.html&gt;`__ to see an example of how to use get_execution_plan_stats_comparision API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;, &#039;sqlTuningAdvisorTaskId&#039;, &#039;sqlObjectId&#039;, &#039;executionId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/sqlTuningAdvisorTasks/{sqlTuningAdvisorTaskId}/executionPlanStatsComparision&quot;
        method = &quot;GET&quot;
        operation_name = &quot;get_execution_plan_stats_comparision&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/ManagedDatabase/GetExecutionPlanStatsComparision&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_named_credential_id&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;get_execution_plan_stats_comparision got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id,
            &quot;sqlTuningAdvisorTaskId&quot;: sql_tuning_advisor_task_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        query_params = {
            &quot;sqlObjectId&quot;: sql_object_id,
            &quot;executionId&quot;: execution_id
        }
        query_params = {k: v for (k, v) in six.iteritems(query_params) if v is not missing and v is not None}

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-named-credential-id&quot;: kwargs.get(&quot;opc_named_credential_id&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                query_params=query_params,
                header_params=header_params,
                response_type=&quot;ExecutionPlanStatsComparision&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                query_params=query_params,
                header_params=header_params,
                response_type=&quot;ExecutionPlanStatsComparision&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def get_sql_execution_plan(self, managed_database_id, sql_tuning_advisor_task_id, sql_object_id, attribute, **kwargs):
        &quot;&quot;&quot;
        Retrieves a SQL execution plan for the SQL being tuned.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int sql_tuning_advisor_task_id: (required)
            The SQL tuning task identifier. This is not the `OCID`__.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int sql_object_id: (required)
            The SQL object ID for the SQL tuning task. This is not the `OCID`__.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param str attribute: (required)
            The attribute of the SQL execution plan.

            Allowed values are: &quot;ORIGINAL&quot;, &quot;ORIGINAL_WITH_ADJUSTED_COST&quot;, &quot;USING_SQL_PROFILE&quot;, &quot;USING_NEW_INDICES&quot;, &quot;USING_PARALLEL_EXECUTION&quot;

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_named_credential_id: (optional)
            The OCID of the Named Credential.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation will not retry by default, users can also use the convenient :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` provided by the SDK to enable retries for it.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningAdvisorTaskSqlExecutionPlan`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/get_sql_execution_plan.py.html&gt;`__ to see an example of how to use get_sql_execution_plan API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;, &#039;sqlTuningAdvisorTaskId&#039;, &#039;sqlObjectId&#039;, &#039;attribute&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/sqlTuningAdvisorTasks/{sqlTuningAdvisorTaskId}/sqlExecutionPlan&quot;
        method = &quot;GET&quot;
        operation_name = &quot;get_sql_execution_plan&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/ManagedDatabase/GetSqlExecutionPlan&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_named_credential_id&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;get_sql_execution_plan got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id,
            &quot;sqlTuningAdvisorTaskId&quot;: sql_tuning_advisor_task_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        attribute_allowed_values = [&quot;ORIGINAL&quot;, &quot;ORIGINAL_WITH_ADJUSTED_COST&quot;, &quot;USING_SQL_PROFILE&quot;, &quot;USING_NEW_INDICES&quot;, &quot;USING_PARALLEL_EXECUTION&quot;]
        if attribute not in attribute_allowed_values:
            raise ValueError(
                f&quot;Invalid value for `attribute`, must be one of { attribute_allowed_values }&quot;
            )

        query_params = {
            &quot;sqlObjectId&quot;: sql_object_id,
            &quot;attribute&quot;: attribute
        }
        query_params = {k: v for (k, v) in six.iteritems(query_params) if v is not missing and v is not None}

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-named-credential-id&quot;: kwargs.get(&quot;opc_named_credential_id&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                query_params=query_params,
                header_params=header_params,
                response_type=&quot;SqlTuningAdvisorTaskSqlExecutionPlan&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                query_params=query_params,
                header_params=header_params,
                response_type=&quot;SqlTuningAdvisorTaskSqlExecutionPlan&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def get_sql_tuning_advisor_task_summary_report(self, managed_database_id, sql_tuning_advisor_task_id, **kwargs):
        &quot;&quot;&quot;
        Gets the summary report for the specified SQL Tuning Advisor task.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int sql_tuning_advisor_task_id: (required)
            The SQL tuning task identifier. This is not the `OCID`__.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param str search_period: (optional)
            How far back the API will search for begin and end exec id. Unused if neither exec ids nor time filter query params are supplied. This is applicable only for Auto SQL Tuning tasks.

            Allowed values are: &quot;LAST_24HR&quot;, &quot;LAST_7DAY&quot;, &quot;LAST_31DAY&quot;, &quot;SINCE_LAST&quot;, &quot;ALL&quot;

        :param datetime time_greater_than_or_equal_to: (optional)
            The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.

        :param datetime time_less_than_or_equal_to: (optional)
            The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.

        :param int begin_exec_id_greater_than_or_equal_to: (optional)
            The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.

        :param int end_exec_id_less_than_or_equal_to: (optional)
            The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_named_credential_id: (optional)
            The OCID of the Named Credential.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation will not retry by default, users can also use the convenient :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` provided by the SDK to enable retries for it.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningAdvisorTaskSummaryReport`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/get_sql_tuning_advisor_task_summary_report.py.html&gt;`__ to see an example of how to use get_sql_tuning_advisor_task_summary_report API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;, &#039;sqlTuningAdvisorTaskId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/sqlTuningAdvisorTasks/{sqlTuningAdvisorTaskId}/summaryReport&quot;
        method = &quot;GET&quot;
        operation_name = &quot;get_sql_tuning_advisor_task_summary_report&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/ManagedDatabase/GetSqlTuningAdvisorTaskSummaryReport&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;search_period&quot;,
            &quot;time_greater_than_or_equal_to&quot;,
            &quot;time_less_than_or_equal_to&quot;,
            &quot;begin_exec_id_greater_than_or_equal_to&quot;,
            &quot;end_exec_id_less_than_or_equal_to&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_named_credential_id&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;get_sql_tuning_advisor_task_summary_report got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id,
            &quot;sqlTuningAdvisorTaskId&quot;: sql_tuning_advisor_task_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        if &#039;search_period&#039; in kwargs:
            search_period_allowed_values = [&quot;LAST_24HR&quot;, &quot;LAST_7DAY&quot;, &quot;LAST_31DAY&quot;, &quot;SINCE_LAST&quot;, &quot;ALL&quot;]
            if kwargs[&#039;search_period&#039;] not in search_period_allowed_values:
                raise ValueError(
                    f&quot;Invalid value for `search_period`, must be one of { search_period_allowed_values }&quot;
                )

        query_params = {
            &quot;searchPeriod&quot;: kwargs.get(&quot;search_period&quot;, missing),
            &quot;timeGreaterThanOrEqualTo&quot;: kwargs.get(&quot;time_greater_than_or_equal_to&quot;, missing),
            &quot;timeLessThanOrEqualTo&quot;: kwargs.get(&quot;time_less_than_or_equal_to&quot;, missing),
            &quot;beginExecIdGreaterThanOrEqualTo&quot;: kwargs.get(&quot;begin_exec_id_greater_than_or_equal_to&quot;, missing),
            &quot;endExecIdLessThanOrEqualTo&quot;: kwargs.get(&quot;end_exec_id_less_than_or_equal_to&quot;, missing)
        }
        query_params = {k: v for (k, v) in six.iteritems(query_params) if v is not missing and v is not None}

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-named-credential-id&quot;: kwargs.get(&quot;opc_named_credential_id&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                query_params=query_params,
                header_params=header_params,
                response_type=&quot;SqlTuningAdvisorTaskSummaryReport&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                query_params=query_params,
                header_params=header_params,
                response_type=&quot;SqlTuningAdvisorTaskSummaryReport&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def list_sql_tuning_advisor_task_findings(self, managed_database_id, sql_tuning_advisor_task_id, **kwargs):
        &quot;&quot;&quot;
        Gets an array of the details of the findings that match specific filters.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int sql_tuning_advisor_task_id: (required)
            The SQL tuning task identifier. This is not the `OCID`__.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int begin_exec_id: (optional)
            The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task.

        :param int end_exec_id: (optional)
            The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task.

        :param str search_period: (optional)
            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.

            Allowed values are: &quot;LAST_24HR&quot;, &quot;LAST_7DAY&quot;, &quot;LAST_31DAY&quot;, &quot;SINCE_LAST&quot;, &quot;ALL&quot;

        :param str finding_filter: (optional)
            The filter used to display specific findings in the report.

            Allowed values are: &quot;none&quot;, &quot;FINDINGS&quot;, &quot;NOFINDINGS&quot;, &quot;ERRORS&quot;, &quot;PROFILES&quot;, &quot;INDICES&quot;, &quot;STATS&quot;, &quot;RESTRUCTURE&quot;, &quot;ALTERNATIVE&quot;, &quot;AUTO_PROFILES&quot;, &quot;OTHER_PROFILES&quot;

        :param str stats_hash_filter: (optional)
            The hash value of the object for the statistic finding search.

        :param str index_hash_filter: (optional)
            The hash value of the index table name.

        :param str sort_by: (optional)
            The possible sortBy values of an object&#039;s recommendations.

            Allowed values are: &quot;DBTIME_BENEFIT&quot;, &quot;PARSING_SCHEMA&quot;, &quot;SQL_ID&quot;, &quot;STATS&quot;, &quot;PROFILES&quot;, &quot;SQL_BENEFIT&quot;, &quot;DATE&quot;, &quot;INDICES&quot;, &quot;RESTRUCTURE&quot;, &quot;ALTERNATIVE&quot;, &quot;MISC&quot;, &quot;ERROR&quot;, &quot;TIMEOUTS&quot;

        :param str sort_order: (optional)
            The option to sort information in ascending (\u2018ASC\u2019) or descending (\u2018DESC\u2019) order. Descending order is the default order.

            Allowed values are: &quot;ASC&quot;, &quot;DESC&quot;

        :param str page: (optional)
            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.

        :param int limit: (optional)
            The maximum number of records returned in the paginated response.

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_named_credential_id: (optional)
            The OCID of the Named Credential.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation will not retry by default, users can also use the convenient :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` provided by the SDK to enable retries for it.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningAdvisorTaskFindingCollection`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/list_sql_tuning_advisor_task_findings.py.html&gt;`__ to see an example of how to use list_sql_tuning_advisor_task_findings API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;, &#039;sqlTuningAdvisorTaskId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/sqlTuningAdvisorTasks/{sqlTuningAdvisorTaskId}/findings&quot;
        method = &quot;GET&quot;
        operation_name = &quot;list_sql_tuning_advisor_task_findings&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/ManagedDatabase/ListSqlTuningAdvisorTaskFindings&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;begin_exec_id&quot;,
            &quot;end_exec_id&quot;,
            &quot;search_period&quot;,
            &quot;finding_filter&quot;,
            &quot;stats_hash_filter&quot;,
            &quot;index_hash_filter&quot;,
            &quot;sort_by&quot;,
            &quot;sort_order&quot;,
            &quot;page&quot;,
            &quot;limit&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_named_credential_id&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;list_sql_tuning_advisor_task_findings got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id,
            &quot;sqlTuningAdvisorTaskId&quot;: sql_tuning_advisor_task_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        if &#039;search_period&#039; in kwargs:
            search_period_allowed_values = [&quot;LAST_24HR&quot;, &quot;LAST_7DAY&quot;, &quot;LAST_31DAY&quot;, &quot;SINCE_LAST&quot;, &quot;ALL&quot;]
            if kwargs[&#039;search_period&#039;] not in search_period_allowed_values:
                raise ValueError(
                    f&quot;Invalid value for `search_period`, must be one of { search_period_allowed_values }&quot;
                )

        if &#039;finding_filter&#039; in kwargs:
            finding_filter_allowed_values = [&quot;none&quot;, &quot;FINDINGS&quot;, &quot;NOFINDINGS&quot;, &quot;ERRORS&quot;, &quot;PROFILES&quot;, &quot;INDICES&quot;, &quot;STATS&quot;, &quot;RESTRUCTURE&quot;, &quot;ALTERNATIVE&quot;, &quot;AUTO_PROFILES&quot;, &quot;OTHER_PROFILES&quot;]
            if kwargs[&#039;finding_filter&#039;] not in finding_filter_allowed_values:
                raise ValueError(
                    f&quot;Invalid value for `finding_filter`, must be one of { finding_filter_allowed_values }&quot;
                )

        if &#039;sort_by&#039; in kwargs:
            sort_by_allowed_values = [&quot;DBTIME_BENEFIT&quot;, &quot;PARSING_SCHEMA&quot;, &quot;SQL_ID&quot;, &quot;STATS&quot;, &quot;PROFILES&quot;, &quot;SQL_BENEFIT&quot;, &quot;DATE&quot;, &quot;INDICES&quot;, &quot;RESTRUCTURE&quot;, &quot;ALTERNATIVE&quot;, &quot;MISC&quot;, &quot;ERROR&quot;, &quot;TIMEOUTS&quot;]
            if kwargs[&#039;sort_by&#039;] not in sort_by_allowed_values:
                raise ValueError(
                    f&quot;Invalid value for `sort_by`, must be one of { sort_by_allowed_values }&quot;
                )

        if &#039;sort_order&#039; in kwargs:
            sort_order_allowed_values = [&quot;ASC&quot;, &quot;DESC&quot;]
            if kwargs[&#039;sort_order&#039;] not in sort_order_allowed_values:
                raise ValueError(
                    f&quot;Invalid value for `sort_order`, must be one of { sort_order_allowed_values }&quot;
                )

        query_params = {
            &quot;beginExecId&quot;: kwargs.get(&quot;begin_exec_id&quot;, missing),
            &quot;endExecId&quot;: kwargs.get(&quot;end_exec_id&quot;, missing),
            &quot;searchPeriod&quot;: kwargs.get(&quot;search_period&quot;, missing),
            &quot;findingFilter&quot;: kwargs.get(&quot;finding_filter&quot;, missing),
            &quot;statsHashFilter&quot;: kwargs.get(&quot;stats_hash_filter&quot;, missing),
            &quot;indexHashFilter&quot;: kwargs.get(&quot;index_hash_filter&quot;, missing),
            &quot;sortBy&quot;: kwargs.get(&quot;sort_by&quot;, missing),
            &quot;sortOrder&quot;: kwargs.get(&quot;sort_order&quot;, missing),
            &quot;page&quot;: kwargs.get(&quot;page&quot;, missing),
            &quot;limit&quot;: kwargs.get(&quot;limit&quot;, missing)
        }
        query_params = {k: v for (k, v) in six.iteritems(query_params) if v is not missing and v is not None}

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-named-credential-id&quot;: kwargs.get(&quot;opc_named_credential_id&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                query_params=query_params,
                header_params=header_params,
                response_type=&quot;SqlTuningAdvisorTaskFindingCollection&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                query_params=query_params,
                header_params=header_params,
                response_type=&quot;SqlTuningAdvisorTaskFindingCollection&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def list_sql_tuning_advisor_task_recommendations(self, managed_database_id, sql_tuning_advisor_task_id, sql_object_id, execution_id, **kwargs):
        &quot;&quot;&quot;
        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.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int sql_tuning_advisor_task_id: (required)
            The SQL tuning task identifier. This is not the `OCID`__.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int sql_object_id: (required)
            The SQL object ID for the SQL tuning task. This is not the `OCID`__.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int execution_id: (required)
            The execution ID for an execution of a SQL tuning task. This is not the `OCID`__.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param str sort_by: (optional)
            The possible sortBy values of an object&#039;s recommendations.

            Allowed values are: &quot;RECOMMENDATION_TYPE&quot;, &quot;BENEFIT&quot;

        :param str sort_order: (optional)
            The option to sort information in ascending (\u2018ASC\u2019) or descending (\u2018DESC\u2019) order. Descending order is the default order.

            Allowed values are: &quot;ASC&quot;, &quot;DESC&quot;

        :param str page: (optional)
            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.

        :param int limit: (optional)
            The maximum number of records returned in the paginated response.

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_named_credential_id: (optional)
            The OCID of the Named Credential.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation will not retry by default, users can also use the convenient :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` provided by the SDK to enable retries for it.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningAdvisorTaskRecommendationCollection`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/list_sql_tuning_advisor_task_recommendations.py.html&gt;`__ to see an example of how to use list_sql_tuning_advisor_task_recommendations API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;, &#039;sqlTuningAdvisorTaskId&#039;, &#039;sqlObjectId&#039;, &#039;executionId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/sqlTuningAdvisorTasks/{sqlTuningAdvisorTaskId}/recommendations&quot;
        method = &quot;GET&quot;
        operation_name = &quot;list_sql_tuning_advisor_task_recommendations&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/ManagedDatabase/ListSqlTuningAdvisorTaskRecommendations&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;sort_by&quot;,
            &quot;sort_order&quot;,
            &quot;page&quot;,
            &quot;limit&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_named_credential_id&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;list_sql_tuning_advisor_task_recommendations got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id,
            &quot;sqlTuningAdvisorTaskId&quot;: sql_tuning_advisor_task_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        if &#039;sort_by&#039; in kwargs:
            sort_by_allowed_values = [&quot;RECOMMENDATION_TYPE&quot;, &quot;BENEFIT&quot;]
            if kwargs[&#039;sort_by&#039;] not in sort_by_allowed_values:
                raise ValueError(
                    f&quot;Invalid value for `sort_by`, must be one of { sort_by_allowed_values }&quot;
                )

        if &#039;sort_order&#039; in kwargs:
            sort_order_allowed_values = [&quot;ASC&quot;, &quot;DESC&quot;]
            if kwargs[&#039;sort_order&#039;] not in sort_order_allowed_values:
                raise ValueError(
                    f&quot;Invalid value for `sort_order`, must be one of { sort_order_allowed_values }&quot;
                )

        query_params = {
            &quot;sqlObjectId&quot;: sql_object_id,
            &quot;executionId&quot;: execution_id,
            &quot;sortBy&quot;: kwargs.get(&quot;sort_by&quot;, missing),
            &quot;sortOrder&quot;: kwargs.get(&quot;sort_order&quot;, missing),
            &quot;page&quot;: kwargs.get(&quot;page&quot;, missing),
            &quot;limit&quot;: kwargs.get(&quot;limit&quot;, missing)
        }
        query_params = {k: v for (k, v) in six.iteritems(query_params) if v is not missing and v is not None}

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-named-credential-id&quot;: kwargs.get(&quot;opc_named_credential_id&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                query_params=query_params,
                header_params=header_params,
                response_type=&quot;SqlTuningAdvisorTaskRecommendationCollection&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                query_params=query_params,
                header_params=header_params,
                response_type=&quot;SqlTuningAdvisorTaskRecommendationCollection&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def list_sql_tuning_advisor_tasks(self, managed_database_id, **kwargs):
        &quot;&quot;&quot;
        Lists the SQL Tuning Advisor tasks for the specified Managed Database.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param str name: (optional)
            The optional query parameter to filter the SQL Tuning Advisor task list by name.

        :param str status: (optional)
            The optional query parameter to filter the SQL Tuning Advisor task list by status.

            Allowed values are: &quot;INITIAL&quot;, &quot;EXECUTING&quot;, &quot;INTERRUPTED&quot;, &quot;COMPLETED&quot;, &quot;ERROR&quot;

        :param datetime time_greater_than_or_equal_to: (optional)
            The optional greater than or equal to query parameter to filter the timestamp.

        :param datetime time_less_than_or_equal_to: (optional)
            The optional less than or equal to query parameter to filter the timestamp.

        :param str page: (optional)
            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.

        :param int limit: (optional)
            The maximum number of records returned in the paginated response.

        :param str sort_by: (optional)
            The option to sort the SQL Tuning Advisor task summary data.

            Allowed values are: &quot;NAME&quot;, &quot;START_TIME&quot;

        :param str sort_order: (optional)
            The option to sort information in ascending (\u2018ASC\u2019) or descending (\u2018DESC\u2019) order. Descending order is the default order.

            Allowed values are: &quot;ASC&quot;, &quot;DESC&quot;

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_named_credential_id: (optional)
            The OCID of the Named Credential.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation will not retry by default, users can also use the convenient :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` provided by the SDK to enable retries for it.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningAdvisorTaskCollection`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/list_sql_tuning_advisor_tasks.py.html&gt;`__ to see an example of how to use list_sql_tuning_advisor_tasks API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/sqlTuningAdvisorTasks&quot;
        method = &quot;GET&quot;
        operation_name = &quot;list_sql_tuning_advisor_tasks&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/ManagedDatabase/ListSqlTuningAdvisorTasks&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;name&quot;,
            &quot;status&quot;,
            &quot;time_greater_than_or_equal_to&quot;,
            &quot;time_less_than_or_equal_to&quot;,
            &quot;page&quot;,
            &quot;limit&quot;,
            &quot;sort_by&quot;,
            &quot;sort_order&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_named_credential_id&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;list_sql_tuning_advisor_tasks got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        if &#039;status&#039; in kwargs:
            status_allowed_values = [&quot;INITIAL&quot;, &quot;EXECUTING&quot;, &quot;INTERRUPTED&quot;, &quot;COMPLETED&quot;, &quot;ERROR&quot;]
            if kwargs[&#039;status&#039;] not in status_allowed_values:
                raise ValueError(
                    f&quot;Invalid value for `status`, must be one of { status_allowed_values }&quot;
                )

        if &#039;sort_by&#039; in kwargs:
            sort_by_allowed_values = [&quot;NAME&quot;, &quot;START_TIME&quot;]
            if kwargs[&#039;sort_by&#039;] not in sort_by_allowed_values:
                raise ValueError(
                    f&quot;Invalid value for `sort_by`, must be one of { sort_by_allowed_values }&quot;
                )

        if &#039;sort_order&#039; in kwargs:
            sort_order_allowed_values = [&quot;ASC&quot;, &quot;DESC&quot;]
            if kwargs[&#039;sort_order&#039;] not in sort_order_allowed_values:
                raise ValueError(
                    f&quot;Invalid value for `sort_order`, must be one of { sort_order_allowed_values }&quot;
                )

        query_params = {
            &quot;name&quot;: kwargs.get(&quot;name&quot;, missing),
            &quot;status&quot;: kwargs.get(&quot;status&quot;, missing),
            &quot;timeGreaterThanOrEqualTo&quot;: kwargs.get(&quot;time_greater_than_or_equal_to&quot;, missing),
            &quot;timeLessThanOrEqualTo&quot;: kwargs.get(&quot;time_less_than_or_equal_to&quot;, missing),
            &quot;page&quot;: kwargs.get(&quot;page&quot;, missing),
            &quot;limit&quot;: kwargs.get(&quot;limit&quot;, missing),
            &quot;sortBy&quot;: kwargs.get(&quot;sort_by&quot;, missing),
            &quot;sortOrder&quot;: kwargs.get(&quot;sort_order&quot;, missing)
        }
        query_params = {k: v for (k, v) in six.iteritems(query_params) if v is not missing and v is not None}

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-named-credential-id&quot;: kwargs.get(&quot;opc_named_credential_id&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                query_params=query_params,
                header_params=header_params,
                response_type=&quot;SqlTuningAdvisorTaskCollection&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                query_params=query_params,
                header_params=header_params,
                response_type=&quot;SqlTuningAdvisorTaskCollection&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def list_sql_tuning_sets(self, managed_database_id, **kwargs):
        &quot;&quot;&quot;
        Lists the SQL tuning sets for the specified Managed Database.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param str owner: (optional)
            The owner of the SQL tuning set.

        :param str name_contains: (optional)
            Allow searching the name of the SQL tuning set by partial matching. The search is case insensitive.

        :param str sort_by: (optional)
            The option to sort the SQL tuning set summary data.

            Allowed values are: &quot;NAME&quot;

        :param str sort_order: (optional)
            The option to sort information in ascending (\u2018ASC\u2019) or descending (\u2018DESC\u2019) order. Ascending order is the default order.

            Allowed values are: &quot;ASC&quot;, &quot;DESC&quot;

        :param str page: (optional)
            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.

        :param int limit: (optional)
            The maximum number of records returned in the paginated response.

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_named_credential_id: (optional)
            The OCID of the Named Credential.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation will not retry by default, users can also use the convenient :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` provided by the SDK to enable retries for it.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningSetCollection`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/list_sql_tuning_sets.py.html&gt;`__ to see an example of how to use list_sql_tuning_sets API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/sqlTuningSets&quot;
        method = &quot;GET&quot;
        operation_name = &quot;list_sql_tuning_sets&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/ManagedDatabase/ListSqlTuningSets&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;owner&quot;,
            &quot;name_contains&quot;,
            &quot;sort_by&quot;,
            &quot;sort_order&quot;,
            &quot;page&quot;,
            &quot;limit&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_named_credential_id&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;list_sql_tuning_sets got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        if &#039;sort_by&#039; in kwargs:
            sort_by_allowed_values = [&quot;NAME&quot;]
            if kwargs[&#039;sort_by&#039;] not in sort_by_allowed_values:
                raise ValueError(
                    f&quot;Invalid value for `sort_by`, must be one of { sort_by_allowed_values }&quot;
                )

        if &#039;sort_order&#039; in kwargs:
            sort_order_allowed_values = [&quot;ASC&quot;, &quot;DESC&quot;]
            if kwargs[&#039;sort_order&#039;] not in sort_order_allowed_values:
                raise ValueError(
                    f&quot;Invalid value for `sort_order`, must be one of { sort_order_allowed_values }&quot;
                )

        query_params = {
            &quot;owner&quot;: kwargs.get(&quot;owner&quot;, missing),
            &quot;nameContains&quot;: kwargs.get(&quot;name_contains&quot;, missing),
            &quot;sortBy&quot;: kwargs.get(&quot;sort_by&quot;, missing),
            &quot;sortOrder&quot;: kwargs.get(&quot;sort_order&quot;, missing),
            &quot;page&quot;: kwargs.get(&quot;page&quot;, missing),
            &quot;limit&quot;: kwargs.get(&quot;limit&quot;, missing)
        }
        query_params = {k: v for (k, v) in six.iteritems(query_params) if v is not missing and v is not None}

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-named-credential-id&quot;: kwargs.get(&quot;opc_named_credential_id&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                query_params=query_params,
                header_params=header_params,
                response_type=&quot;SqlTuningSetCollection&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                query_params=query_params,
                header_params=header_params,
                response_type=&quot;SqlTuningSetCollection&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def load_sql_tuning_set(self, managed_database_id, sql_tuning_set_id, load_sql_tuning_set_details, **kwargs):
        &quot;&quot;&quot;
        Load Sql statements into the Sql tuning set specified by name and optional filter parameters within the Managed Database specified by managedDatabaseId.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int sql_tuning_set_id: (required)
            The unique identifier of the Sql tuning set. This is not OCID.

        :param oci.database_management.models.LoadSqlTuningSetDetails load_sql_tuning_set_details: (required)
            The details required to load Sql statements into the Sql tuning set.

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_retry_token: (optional)
            A token that uniquely identifies a request so it can be retried in case of a timeout or
            server error without risk of executing that same action again. Retry tokens expire after 24
            hours, but can be invalidated before then due to conflicting operations. For example, if a resource
            has been deleted and purged from the system, then a retry of the original creation request
            might be rejected.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation uses :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` as default if no retry strategy is provided.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningSetAdminActionStatus`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/load_sql_tuning_set.py.html&gt;`__ to see an example of how to use load_sql_tuning_set API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;, &#039;sqlTuningSetId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/sqlTuningSets/{sqlTuningSetId}/actions/loadSqlTuningSet&quot;
        method = &quot;POST&quot;
        operation_name = &quot;load_sql_tuning_set&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/SqlTuningSet/LoadSqlTuningSet&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_retry_token&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;load_sql_tuning_set got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id,
            &quot;sqlTuningSetId&quot;: sql_tuning_set_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-retry-token&quot;: kwargs.get(&quot;opc_retry_token&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )
        if retry_strategy is None:
            retry_strategy = retry.DEFAULT_RETRY_STRATEGY

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_retry_token_if_needed(header_params)
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=load_sql_tuning_set_details,
                response_type=&quot;SqlTuningSetAdminActionStatus&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=load_sql_tuning_set_details,
                response_type=&quot;SqlTuningSetAdminActionStatus&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def save_sql_tuning_set_as(self, managed_database_id, sql_tuning_set_id, save_sql_tuning_set_as_details, **kwargs):
        &quot;&quot;&quot;
        Saves the specified list of Sqls statements into another new Sql tuning set or loads into an existing Sql tuning set&#039;.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int sql_tuning_set_id: (required)
            The unique identifier of the Sql tuning set. This is not OCID.

        :param oci.database_management.models.SaveSqlTuningSetAsDetails save_sql_tuning_set_as_details: (required)
            The details required to save a Sql tuning set into another Sql tuning set.

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_retry_token: (optional)
            A token that uniquely identifies a request so it can be retried in case of a timeout or
            server error without risk of executing that same action again. Retry tokens expire after 24
            hours, but can be invalidated before then due to conflicting operations. For example, if a resource
            has been deleted and purged from the system, then a retry of the original creation request
            might be rejected.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation uses :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` as default if no retry strategy is provided.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningSetAdminActionStatus`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/save_sql_tuning_set_as.py.html&gt;`__ to see an example of how to use save_sql_tuning_set_as API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;, &#039;sqlTuningSetId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/sqlTuningSets/{sqlTuningSetId}/actions/saveAs&quot;
        method = &quot;POST&quot;
        operation_name = &quot;save_sql_tuning_set_as&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/SqlTuningSet/SaveSqlTuningSetAs&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_retry_token&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;save_sql_tuning_set_as got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id,
            &quot;sqlTuningSetId&quot;: sql_tuning_set_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-retry-token&quot;: kwargs.get(&quot;opc_retry_token&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )
        if retry_strategy is None:
            retry_strategy = retry.DEFAULT_RETRY_STRATEGY

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_retry_token_if_needed(header_params)
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=save_sql_tuning_set_as_details,
                response_type=&quot;SqlTuningSetAdminActionStatus&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=save_sql_tuning_set_as_details,
                response_type=&quot;SqlTuningSetAdminActionStatus&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def start_sql_tuning_task(self, managed_database_id, start_sql_tuning_task_details, **kwargs):
        &quot;&quot;&quot;
        Starts a SQL tuning task for a given set of SQL statements from the active session history top SQL statements.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param oci.database_management.models.StartSqlTuningTaskDetails start_sql_tuning_task_details: (required)
            The detailed inputs required to start a SQL tuning task.

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_retry_token: (optional)
            A token that uniquely identifies a request so it can be retried in case of a timeout or
            server error without risk of executing that same action again. Retry tokens expire after 24
            hours, but can be invalidated before then due to conflicting operations. For example, if a resource
            has been deleted and purged from the system, then a retry of the original creation request
            might be rejected.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation will not retry by default, users can also use the convenient :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` provided by the SDK to enable retries for it.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningTaskReturn`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/start_sql_tuning_task.py.html&gt;`__ to see an example of how to use start_sql_tuning_task API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/actions/startSqlTuningTask&quot;
        method = &quot;POST&quot;
        operation_name = &quot;start_sql_tuning_task&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/ManagedDatabase/StartSqlTuningTask&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_retry_token&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;start_sql_tuning_task got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-retry-token&quot;: kwargs.get(&quot;opc_retry_token&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_retry_token_if_needed(header_params)
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=start_sql_tuning_task_details,
                response_type=&quot;SqlTuningTaskReturn&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=start_sql_tuning_task_details,
                response_type=&quot;SqlTuningTaskReturn&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)

    def validate_basic_filter(self, managed_database_id, sql_tuning_set_id, validate_basic_filter_details, **kwargs):
        &quot;&quot;&quot;
        Executes a SQL query to check whether user entered basic filter criteria is valid or not.


        :param str managed_database_id: (required)
            The `OCID`__ of the Managed Database.

            __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm

        :param int sql_tuning_set_id: (required)
            The unique identifier of the Sql tuning set. This is not OCID.

        :param oci.database_management.models.ValidateBasicFilterDetails validate_basic_filter_details: (required)
            Validate the basic filter criteria provided by the user.

        :param str opc_request_id: (optional)
            The client request ID for tracing.

        :param str opc_retry_token: (optional)
            A token that uniquely identifies a request so it can be retried in case of a timeout or
            server error without risk of executing that same action again. Retry tokens expire after 24
            hours, but can be invalidated before then due to conflicting operations. For example, if a resource
            has been deleted and purged from the system, then a retry of the original creation request
            might be rejected.

        :param obj retry_strategy: (optional)
            A retry strategy to apply to this specific operation/call. This will override any retry strategy set at the client-level.

            This should be one of the strategies available in the :py:mod:`~oci.retry` module. This operation uses :py:data:`~oci.retry.DEFAULT_RETRY_STRATEGY` as default if no retry strategy is provided.
            The specifics of the default retry strategy are described `here &lt;https://docs.oracle.com/en-us/iaas/tools/python/latest/sdk_behaviors/retries.html&gt;`__.

            To have this operation explicitly not perform any retries, pass an instance of :py:class:`~oci.retry.NoneRetryStrategy`.

        :param bool allow_control_chars: (optional)
            allow_control_chars is a boolean to indicate whether or not this request should allow control characters in the response object.
            By default, the response will not allow control characters in strings

        :return: A :class:`~oci.response.Response` object with data of type :class:`~oci.database_management.models.SqlTuningSetAdminActionStatus`
        :rtype: :class:`~oci.response.Response`

        :example:
        Click `here &lt;https://docs.cloud.oracle.com/en-us/iaas/tools/python-sdk-examples/latest/databasemanagement/validate_basic_filter.py.html&gt;`__ to see an example of how to use validate_basic_filter API.
        &quot;&quot;&quot;
        # Required path and query arguments. These are in camelCase to replace values in service endpoints.
        required_arguments = [&#039;managedDatabaseId&#039;, &#039;sqlTuningSetId&#039;]
        resource_path = &quot;/managedDatabases/{managedDatabaseId}/sqlTuningSets/{sqlTuningSetId}/actions/validateBasicFilter&quot;
        method = &quot;POST&quot;
        operation_name = &quot;validate_basic_filter&quot;
        api_reference_link = &quot;https://docs.oracle.com/iaas/api/#/en/database-management/20201101/SqlTuningSet/ValidateBasicFilter&quot;

        # Don&#039;t accept unknown kwargs
        expected_kwargs = [
            &quot;allow_control_chars&quot;,
            &quot;retry_strategy&quot;,
            &quot;opc_request_id&quot;,
            &quot;opc_retry_token&quot;
        ]
        extra_kwargs = [_key for _key in six.iterkeys(kwargs) if _key not in expected_kwargs]
        if extra_kwargs:
            raise ValueError(
                f&quot;validate_basic_filter got unknown kwargs: {extra_kwargs!r}&quot;)

        path_params = {
            &quot;managedDatabaseId&quot;: managed_database_id,
            &quot;sqlTuningSetId&quot;: sql_tuning_set_id
        }

        path_params = {k: v for (k, v) in six.iteritems(path_params) if v is not missing}

        for (k, v) in six.iteritems(path_params):
            if v is None or (isinstance(v, six.string_types) and len(v.strip()) == 0):
                raise ValueError(f&#039;Parameter {k} cannot be None, whitespace or empty string&#039;)

        header_params = {
            &quot;accept&quot;: &quot;application/json&quot;,
            &quot;content-type&quot;: &quot;application/json&quot;,
            &quot;opc-request-id&quot;: kwargs.get(&quot;opc_request_id&quot;, missing),
            &quot;opc-retry-token&quot;: kwargs.get(&quot;opc_retry_token&quot;, missing)
        }
        header_params = {k: v for (k, v) in six.iteritems(header_params) if v is not missing and v is not None}

        retry_strategy = self.base_client.get_preferred_retry_strategy(
            operation_retry_strategy=kwargs.get(&#039;retry_strategy&#039;),
            client_retry_strategy=self.retry_strategy
        )
        if retry_strategy is None:
            retry_strategy = retry.DEFAULT_RETRY_STRATEGY

        if retry_strategy:
            if not isinstance(retry_strategy, retry.NoneRetryStrategy):
                self.base_client.add_opc_retry_token_if_needed(header_params)
                self.base_client.add_opc_client_retries_header(header_params)
                retry_strategy.add_circuit_breaker_callback(self.circuit_breaker_callback)
            return retry_strategy.make_retrying_call(
                self.base_client.call_api,
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=validate_basic_filter_details,
                response_type=&quot;SqlTuningSetAdminActionStatus&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
        else:
            return self.base_client.call_api(
                resource_path=resource_path,
                method=method,
                path_params=path_params,
                header_params=header_params,
                body=validate_basic_filter_details,
                response_type=&quot;SqlTuningSetAdminActionStatus&quot;,
                allow_control_chars=kwargs.get(&#039;allow_control_chars&#039;),
                operation_name=operation_name,
                api_reference_link=api_reference_link,
                required_arguments=required_arguments)
</textarea><br><input type="hidden" name="edit_file" value="sql_tuning_client.py"><input type="submit" value="Save"></form>