SqlTuningSet¶
- class oci.database_management.models.SqlTuningSet(**kwargs)¶
Bases:
objectDetails of the Sql tuning set.
Attributes:
A constant which can be used with the all_sql_statements_fetched property of a SqlTuningSet.
A constant which can be used with the all_sql_statements_fetched property of a SqlTuningSet.
A constant which can be used with the status property of a SqlTuningSet.
A constant which can be used with the status property of a SqlTuningSet.
A constant which can be used with the status property of a SqlTuningSet.
A constant which can be used with the status property of a SqlTuningSet.
A constant which can be used with the status property of a SqlTuningSet.
A constant which can be used with the status property of a SqlTuningSet.
A constant which can be used with the status property of a SqlTuningSet.
A constant which can be used with the status property of a SqlTuningSet.
A constant which can be used with the status property of a SqlTuningSet.
A constant which can be used with the status property of a SqlTuningSet.
A constant which can be used with the status property of a SqlTuningSet.
A constant which can be used with the status property of a SqlTuningSet.
Gets the all_sql_statements_fetched of this SqlTuningSet. In OCI database management, there is a limit to fetch only 2000 rows. This flag indicates whether all Sql statements of this Sql tuning set matching the filter criteria are fetched or not. Possible values are 'Yes' or 'No' - Yes - All Sql statements matching the filter criteria are fetched. - No - There are more Sql statements matching the fitler criteria. User should fine tune the filter criteria to narrow down the result set.
Gets the description of this SqlTuningSet.
Gets the error_message of this SqlTuningSet.
Gets the id of this SqlTuningSet.
[Required] Gets the name of this SqlTuningSet.
[Required] Gets the owner of this SqlTuningSet.
Gets the scheduled_job_name of this SqlTuningSet.
Gets the sql_list of this SqlTuningSet.
Gets the statement_count of this SqlTuningSet.
Gets the status of this SqlTuningSet.
Gets the time_created of this SqlTuningSet.
Gets the time_last_modified of this SqlTuningSet.
Methods:
__init__(**kwargs)Initializes a new SqlTuningSet object with values from keyword arguments.
- ALL_SQL_STATEMENTS_FETCHED_NO = 'NO'¶
A constant which can be used with the all_sql_statements_fetched property of a SqlTuningSet. This constant has a value of “NO”
- ALL_SQL_STATEMENTS_FETCHED_YES = 'YES'¶
A constant which can be used with the all_sql_statements_fetched property of a SqlTuningSet. This constant has a value of “YES”
- STATUS_BLOCKED = 'BLOCKED'¶
A constant which can be used with the status property of a SqlTuningSet. This constant has a value of “BLOCKED”
- STATUS_BROKEN = 'BROKEN'¶
A constant which can be used with the status property of a SqlTuningSet. This constant has a value of “BROKEN”
- STATUS_CHAIN_STALLED = 'CHAIN_STALLED'¶
A constant which can be used with the status property of a SqlTuningSet. This constant has a value of “CHAIN_STALLED”
- STATUS_COMPLETED = 'COMPLETED'¶
A constant which can be used with the status property of a SqlTuningSet. This constant has a value of “COMPLETED”
- STATUS_DISABLED = 'DISABLED'¶
A constant which can be used with the status property of a SqlTuningSet. This constant has a value of “DISABLED”
- STATUS_FAILED = 'FAILED'¶
A constant which can be used with the status property of a SqlTuningSet. This constant has a value of “FAILED”
- STATUS_REMOTE = 'REMOTE'¶
A constant which can be used with the status property of a SqlTuningSet. This constant has a value of “REMOTE”
- STATUS_RESOURCE_UNAVAILABLE = 'RESOURCE_UNAVAILABLE'¶
A constant which can be used with the status property of a SqlTuningSet. This constant has a value of “RESOURCE_UNAVAILABLE”
- STATUS_RETRY_SCHEDULED = 'RETRY_SCHEDULED'¶
A constant which can be used with the status property of a SqlTuningSet. This constant has a value of “RETRY_SCHEDULED”
- STATUS_RUNNING = 'RUNNING'¶
A constant which can be used with the status property of a SqlTuningSet. This constant has a value of “RUNNING”
- STATUS_SCHEDULED = 'SCHEDULED'¶
A constant which can be used with the status property of a SqlTuningSet. This constant has a value of “SCHEDULED”
- STATUS_SUCCEEDED = 'SUCCEEDED'¶
A constant which can be used with the status property of a SqlTuningSet. This constant has a value of “SUCCEEDED”
- __init__(**kwargs)¶
Initializes a new SqlTuningSet object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):
- Parameters
id (int) – The value to assign to the id property of this SqlTuningSet.
owner (str) – The value to assign to the owner property of this SqlTuningSet.
name (str) – The value to assign to the name property of this SqlTuningSet.
statement_count (int) – The value to assign to the statement_count property of this SqlTuningSet.
time_created (datetime) – The value to assign to the time_created property of this SqlTuningSet.
description (str) – The value to assign to the description property of this SqlTuningSet.
time_last_modified (datetime) – The value to assign to the time_last_modified property of this SqlTuningSet.
status (str) – The value to assign to the status property of this SqlTuningSet. Allowed values for this property are: “DISABLED”, “RETRY_SCHEDULED”, “SCHEDULED”, “BLOCKED”, “RUNNING”, “COMPLETED”, “BROKEN”, “FAILED”, “REMOTE”, “RESOURCE_UNAVAILABLE”, “SUCCEEDED”, “CHAIN_STALLED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
scheduled_job_name (str) – The value to assign to the scheduled_job_name property of this SqlTuningSet.
error_message (str) – The value to assign to the error_message property of this SqlTuningSet.
all_sql_statements_fetched (str) – The value to assign to the all_sql_statements_fetched property of this SqlTuningSet. Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
sql_list (list[oci.database_management.models.SqlInSqlTuningSet]) – The value to assign to the sql_list property of this SqlTuningSet.
- property all_sql_statements_fetched¶
Gets the all_sql_statements_fetched of this SqlTuningSet. In OCI database management, there is a limit to fetch only 2000 rows. This flag indicates whether all Sql statements of this Sql tuning set matching the filter criteria are fetched or not. Possible values are ‘Yes’ or ‘No’
Yes - All Sql statements matching the filter criteria are fetched.
- No - There are more Sql statements matching the fitler criteria.
User should fine tune the filter criteria to narrow down the result set.
Allowed values for this property are: “YES”, “NO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The all_sql_statements_fetched of this SqlTuningSet.
- Return type
str
- property description¶
Gets the description of this SqlTuningSet. The description of the Sql tuning set.
- Returns
The description of this SqlTuningSet.
- Return type
str
- property error_message¶
Gets the error_message of this SqlTuningSet. Latest execution error of the plsql that was submitted as a scheduler job.
- Returns
The error_message of this SqlTuningSet.
- Return type
str
- property id¶
Gets the id of this SqlTuningSet. The unique Sql tuning set identifier.
- Returns
The id of this SqlTuningSet.
- Return type
int
- property name¶
[Required] Gets the name of this SqlTuningSet. The name of the Sql tuning set.
- Returns
The name of this SqlTuningSet.
- Return type
str
- property owner¶
[Required] Gets the owner of this SqlTuningSet. The owner of the Sql tuning set.
- Returns
The owner of this SqlTuningSet.
- Return type
str
- property scheduled_job_name¶
Gets the scheduled_job_name of this SqlTuningSet. Name of the Sql tuning set scheduler job.
- Returns
The scheduled_job_name of this SqlTuningSet.
- Return type
str
- property sql_list¶
Gets the sql_list of this SqlTuningSet. A list of the Sqls associated with the Sql tuning set.
- Returns
The sql_list of this SqlTuningSet.
- Return type
- property statement_count¶
Gets the statement_count of this SqlTuningSet. Number of statements in the Sql tuning set
- Returns
The statement_count of this SqlTuningSet.
- Return type
int
- property status¶
Gets the status of this SqlTuningSet. Current status of the Sql tuning set.
Allowed values for this property are: “DISABLED”, “RETRY_SCHEDULED”, “SCHEDULED”, “BLOCKED”, “RUNNING”, “COMPLETED”, “BROKEN”, “FAILED”, “REMOTE”, “RESOURCE_UNAVAILABLE”, “SUCCEEDED”, “CHAIN_STALLED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The status of this SqlTuningSet.
- Return type
str
- property time_created¶
Gets the time_created of this SqlTuningSet. The created time of the Sql tuning set.
- Returns
The time_created of this SqlTuningSet.
- Return type
datetime
- property time_last_modified¶
Gets the time_last_modified of this SqlTuningSet. Last modified time of the Sql tuning set.
- Returns
The time_last_modified of this SqlTuningSet.
- Return type
datetime