DropSqlsInSqlTuningSetDetails

class oci.database_management.models.DropSqlsInSqlTuningSetDetails(**kwargs)

Bases: object

Drops the selected list of Sql statements from the current Sql tuning set. The basicFilter parameter specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW. If a valid filter criteria is specified, then, Sql statements matching this filter criteria will be deleted from the current Sql tuning set. If filter criteria is not specified, then, all Sql statements will be deleted from the current Sql tuning set. It takes either credentialDetails or databaseCredential. It’s recommended to provide databaseCredential

Methods:

__init__(**kwargs)

Initializes a new DropSqlsInSqlTuningSetDetails object with values from keyword arguments.

Attributes:

basic_filter

Gets the basic_filter of this DropSqlsInSqlTuningSetDetails.

credential_details

Gets the credential_details of this DropSqlsInSqlTuningSetDetails.

database_credential

Gets the database_credential of this DropSqlsInSqlTuningSetDetails.

name

[Required] Gets the name of this DropSqlsInSqlTuningSetDetails.

owner

Gets the owner of this DropSqlsInSqlTuningSetDetails.

show_sql_only

Gets the show_sql_only of this DropSqlsInSqlTuningSetDetails.

__init__(**kwargs)

Initializes a new DropSqlsInSqlTuningSetDetails object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters
  • credential_details (oci.database_management.models.SqlTuningSetAdminCredentialDetails) – The value to assign to the credential_details property of this DropSqlsInSqlTuningSetDetails.

  • database_credential (oci.database_management.models.DatabaseCredentialDetails) – The value to assign to the database_credential property of this DropSqlsInSqlTuningSetDetails.

  • show_sql_only (int) – The value to assign to the show_sql_only property of this DropSqlsInSqlTuningSetDetails.

  • owner (str) – The value to assign to the owner property of this DropSqlsInSqlTuningSetDetails.

  • name (str) – The value to assign to the name property of this DropSqlsInSqlTuningSetDetails.

  • basic_filter (str) – The value to assign to the basic_filter property of this DropSqlsInSqlTuningSetDetails.

property basic_filter

Gets the basic_filter of this DropSqlsInSqlTuningSetDetails. Specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW. User could use any combination of the following columns with appropriate values as Sql predicate Refer to the documentation https://docs.oracle.com/en/database/oracle/oracle-database/18/arpls/DBMS_SQLTUNE.html#GUID-1F4AFB03-7B29-46FC-B3F2-CB01EC36326C

Returns

The basic_filter of this DropSqlsInSqlTuningSetDetails.

Return type

str

property credential_details

Gets the credential_details of this DropSqlsInSqlTuningSetDetails.

Returns

The credential_details of this DropSqlsInSqlTuningSetDetails.

Return type

oci.database_management.models.SqlTuningSetAdminCredentialDetails

property database_credential

Gets the database_credential of this DropSqlsInSqlTuningSetDetails.

Returns

The database_credential of this DropSqlsInSqlTuningSetDetails.

Return type

oci.database_management.models.DatabaseCredentialDetails

property name

[Required] Gets the name of this DropSqlsInSqlTuningSetDetails. The name of the Sql tuning set.

Returns

The name of this DropSqlsInSqlTuningSetDetails.

Return type

str

property owner

Gets the owner of this DropSqlsInSqlTuningSetDetails. The owner of the Sql tuning set.

Returns

The owner of this DropSqlsInSqlTuningSetDetails.

Return type

str

property show_sql_only

Gets the show_sql_only of this DropSqlsInSqlTuningSetDetails. Flag to indicate whether to drop the Sql statements or just display the plsql used to drop the Sql statements.

Returns

The show_sql_only of this DropSqlsInSqlTuningSetDetails.

Return type

int