SqlTuningSetSummary¶
- class oci.database_management.models.SqlTuningSetSummary(**kwargs)¶
Bases:
objectThe summary information of a SQL tuning set.
Attributes:
A constant which can be used with the status property of a SqlTuningSetSummary.
A constant which can be used with the status property of a SqlTuningSetSummary.
A constant which can be used with the status property of a SqlTuningSetSummary.
A constant which can be used with the status property of a SqlTuningSetSummary.
A constant which can be used with the status property of a SqlTuningSetSummary.
A constant which can be used with the status property of a SqlTuningSetSummary.
A constant which can be used with the status property of a SqlTuningSetSummary.
A constant which can be used with the status property of a SqlTuningSetSummary.
A constant which can be used with the status property of a SqlTuningSetSummary.
A constant which can be used with the status property of a SqlTuningSetSummary.
A constant which can be used with the status property of a SqlTuningSetSummary.
A constant which can be used with the status property of a SqlTuningSetSummary.
Gets the description of this SqlTuningSetSummary.
Gets the error_message of this SqlTuningSetSummary.
Gets the id of this SqlTuningSetSummary.
[Required] Gets the name of this SqlTuningSetSummary.
[Required] Gets the owner of this SqlTuningSetSummary.
Gets the scheduled_job_name of this SqlTuningSetSummary.
Gets the statement_counts of this SqlTuningSetSummary.
Gets the status of this SqlTuningSetSummary.
Gets the time_created of this SqlTuningSetSummary.
Gets the time_last_modified of this SqlTuningSetSummary.
Methods:
__init__(**kwargs)Initializes a new SqlTuningSetSummary object with values from keyword arguments.
- STATUS_BLOCKED = 'BLOCKED'¶
A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “BLOCKED”
- STATUS_BROKEN = 'BROKEN'¶
A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “BROKEN”
- STATUS_CHAIN_STALLED = 'CHAIN_STALLED'¶
A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “CHAIN_STALLED”
- STATUS_COMPLETED = 'COMPLETED'¶
A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “COMPLETED”
- STATUS_DISABLED = 'DISABLED'¶
A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “DISABLED”
- STATUS_FAILED = 'FAILED'¶
A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “FAILED”
- STATUS_REMOTE = 'REMOTE'¶
A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “REMOTE”
- STATUS_RESOURCE_UNAVAILABLE = 'RESOURCE_UNAVAILABLE'¶
A constant which can be used with the status property of a SqlTuningSetSummary. 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 SqlTuningSetSummary. This constant has a value of “RETRY_SCHEDULED”
- STATUS_RUNNING = 'RUNNING'¶
A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “RUNNING”
- STATUS_SCHEDULED = 'SCHEDULED'¶
A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “SCHEDULED”
- STATUS_SUCCEEDED = 'SUCCEEDED'¶
A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “SUCCEEDED”
- __init__(**kwargs)¶
Initializes a new SqlTuningSetSummary object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):
- Parameters
name (str) – The value to assign to the name property of this SqlTuningSetSummary.
owner (str) – The value to assign to the owner property of this SqlTuningSetSummary.
description (str) – The value to assign to the description property of this SqlTuningSetSummary.
statement_counts (int) – The value to assign to the statement_counts property of this SqlTuningSetSummary.
id (int) – The value to assign to the id property of this SqlTuningSetSummary.
time_created (datetime) – The value to assign to the time_created property of this SqlTuningSetSummary.
time_last_modified (datetime) – The value to assign to the time_last_modified property of this SqlTuningSetSummary.
status (str) – The value to assign to the status property of this SqlTuningSetSummary. 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 SqlTuningSetSummary.
error_message (str) – The value to assign to the error_message property of this SqlTuningSetSummary.
- property description¶
Gets the description of this SqlTuningSetSummary. The description of the SQL tuning set.
- Returns
The description of this SqlTuningSetSummary.
- Return type
str
- property error_message¶
Gets the error_message of this SqlTuningSetSummary. Latest execution error of the plsql that was submitted as a scheduler job.
- Returns
The error_message of this SqlTuningSetSummary.
- Return type
str
- property id¶
Gets the id of this SqlTuningSetSummary. The unique Sql tuning set identifier. This is not OCID.
- Returns
The id of this SqlTuningSetSummary.
- Return type
int
- property name¶
[Required] Gets the name of this SqlTuningSetSummary. The name of the SQL tuning set.
- Returns
The name of this SqlTuningSetSummary.
- Return type
str
- property owner¶
[Required] Gets the owner of this SqlTuningSetSummary. The owner of the SQL tuning set.
- Returns
The owner of this SqlTuningSetSummary.
- Return type
str
- property scheduled_job_name¶
Gets the scheduled_job_name of this SqlTuningSetSummary. Name of the Sql tuning set scheduler job.
- Returns
The scheduled_job_name of this SqlTuningSetSummary.
- Return type
str
- property statement_counts¶
Gets the statement_counts of this SqlTuningSetSummary. The number of SQL statements in the SQL tuning set.
- Returns
The statement_counts of this SqlTuningSetSummary.
- Return type
int
- property status¶
Gets the status of this SqlTuningSetSummary. 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 SqlTuningSetSummary.
- Return type
str
- property time_created¶
Gets the time_created of this SqlTuningSetSummary. The created time of the Sql tuning set.
- Returns
The time_created of this SqlTuningSetSummary.
- Return type
datetime
- property time_last_modified¶
Gets the time_last_modified of this SqlTuningSetSummary. Last modified time of the Sql tuning set.
- Returns
The time_last_modified of this SqlTuningSetSummary.
- Return type
datetime