DropSqlsInSqlTuningSetDetails¶
- class oci.database_management.models.DropSqlsInSqlTuningSetDetails(**kwargs)¶
Bases:
objectDrops 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:
Gets the basic_filter of this DropSqlsInSqlTuningSetDetails.
Gets the credential_details of this DropSqlsInSqlTuningSetDetails.
Gets the database_credential of this DropSqlsInSqlTuningSetDetails.
[Required] Gets the name of this DropSqlsInSqlTuningSetDetails.
Gets the owner of this DropSqlsInSqlTuningSetDetails.
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
- 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