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.

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

credential_details¶

Gets the credential_details of this DropSqlsInSqlTuningSetDetails.

Returns:	The credential_details of this DropSqlsInSqlTuningSetDetails.
Return type:	oci.database_management.models.SqlTuningSetAdminCredentialDetails

database_credential¶

Gets the database_credential of this DropSqlsInSqlTuningSetDetails.

Returns:	The database_credential of this DropSqlsInSqlTuningSetDetails.
Return type:	oci.database_management.models.DatabaseCredentialDetails

name¶

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

Returns:	The name of this DropSqlsInSqlTuningSetDetails.
Return type:	str

owner¶

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

Returns:	The owner of this DropSqlsInSqlTuningSetDetails.
Return type:	str

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