SqlTuningAdvisorTaskSummary¶
- class oci.database_management.models.SqlTuningAdvisorTaskSummary(**kwargs)¶
Bases:
objectThe summary of a SQL Tuning Advisor task.
Attributes:
A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary.
A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary.
A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary.
A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary.
A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary.
Gets the days_to_expire of this SqlTuningAdvisorTaskSummary.
Gets the description of this SqlTuningAdvisorTaskSummary.
Gets the instance_id of this SqlTuningAdvisorTaskSummary.
Gets the name of this SqlTuningAdvisorTaskSummary.
Gets the owner of this SqlTuningAdvisorTaskSummary.
Gets the recommendation_count of this SqlTuningAdvisorTaskSummary.
[Required] Gets the sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskSummary.
Gets the task_status of this SqlTuningAdvisorTaskSummary.
Gets the time_created of this SqlTuningAdvisorTaskSummary.
Gets the time_execution_ended of this SqlTuningAdvisorTaskSummary.
Gets the time_execution_started of this SqlTuningAdvisorTaskSummary.
Gets the total_sql_statements of this SqlTuningAdvisorTaskSummary.
Methods:
__init__(**kwargs)Initializes a new SqlTuningAdvisorTaskSummary object with values from keyword arguments.
- TASK_STATUS_COMPLETED = 'COMPLETED'¶
A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary. This constant has a value of “COMPLETED”
- TASK_STATUS_ERROR = 'ERROR'¶
A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary. This constant has a value of “ERROR”
- TASK_STATUS_EXECUTING = 'EXECUTING'¶
A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary. This constant has a value of “EXECUTING”
- TASK_STATUS_INITIAL = 'INITIAL'¶
A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary. This constant has a value of “INITIAL”
- TASK_STATUS_INTERRUPTED = 'INTERRUPTED'¶
A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary. This constant has a value of “INTERRUPTED”
- __init__(**kwargs)¶
Initializes a new SqlTuningAdvisorTaskSummary object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):
- Parameters
sql_tuning_advisor_task_id (int) – The value to assign to the sql_tuning_advisor_task_id property of this SqlTuningAdvisorTaskSummary.
instance_id (int) – The value to assign to the instance_id property of this SqlTuningAdvisorTaskSummary.
name (str) – The value to assign to the name property of this SqlTuningAdvisorTaskSummary.
description (str) – The value to assign to the description property of this SqlTuningAdvisorTaskSummary.
owner (str) – The value to assign to the owner property of this SqlTuningAdvisorTaskSummary.
time_created (datetime) – The value to assign to the time_created property of this SqlTuningAdvisorTaskSummary.
task_status (str) – The value to assign to the task_status property of this SqlTuningAdvisorTaskSummary. Allowed values for this property are: “COMPLETED”, “INITIAL”, “EXECUTING”, “INTERRUPTED”, “ERROR”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
days_to_expire (int) – The value to assign to the days_to_expire property of this SqlTuningAdvisorTaskSummary.
time_execution_started (datetime) – The value to assign to the time_execution_started property of this SqlTuningAdvisorTaskSummary.
time_execution_ended (datetime) – The value to assign to the time_execution_ended property of this SqlTuningAdvisorTaskSummary.
total_sql_statements (int) – The value to assign to the total_sql_statements property of this SqlTuningAdvisorTaskSummary.
recommendation_count (int) – The value to assign to the recommendation_count property of this SqlTuningAdvisorTaskSummary.
- property days_to_expire¶
Gets the days_to_expire of this SqlTuningAdvisorTaskSummary. The number of days left before the task expires. If the value equals -1, then the task has no expiration time (UNLIMITED).
- Returns
The days_to_expire of this SqlTuningAdvisorTaskSummary.
- Return type
int
- property description¶
Gets the description of this SqlTuningAdvisorTaskSummary. The description of the SQL Tuning Advisor task.
- Returns
The description of this SqlTuningAdvisorTaskSummary.
- Return type
str
- property instance_id¶
Gets the instance_id of this SqlTuningAdvisorTaskSummary. The instance ID of the SQL Tuning Advisor task. This is not the OCID.
- Returns
The instance_id of this SqlTuningAdvisorTaskSummary.
- Return type
int
- property name¶
Gets the name of this SqlTuningAdvisorTaskSummary. The name of the SQL Tuning Advisor task.
- Returns
The name of this SqlTuningAdvisorTaskSummary.
- Return type
str
- property owner¶
Gets the owner of this SqlTuningAdvisorTaskSummary. The owner of the SQL Tuning Advisor task.
- Returns
The owner of this SqlTuningAdvisorTaskSummary.
- Return type
str
- property recommendation_count¶
Gets the recommendation_count of this SqlTuningAdvisorTaskSummary. The number of recommendations provided for the SQL Tuning Advisor task.
- Returns
The recommendation_count of this SqlTuningAdvisorTaskSummary.
- Return type
int
- property sql_tuning_advisor_task_id¶
[Required] Gets the sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskSummary. The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
- Returns
The sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskSummary.
- Return type
int
- property task_status¶
Gets the task_status of this SqlTuningAdvisorTaskSummary. The status of the SQL Tuning Advisor task.
Allowed values for this property are: “COMPLETED”, “INITIAL”, “EXECUTING”, “INTERRUPTED”, “ERROR”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The task_status of this SqlTuningAdvisorTaskSummary.
- Return type
str
- property time_created¶
Gets the time_created of this SqlTuningAdvisorTaskSummary. The Creation date of the SQL Tuning Advisor task.
- Returns
The time_created of this SqlTuningAdvisorTaskSummary.
- Return type
datetime
- property time_execution_ended¶
Gets the time_execution_ended of this SqlTuningAdvisorTaskSummary. The end time of the task execution.
- Returns
The time_execution_ended of this SqlTuningAdvisorTaskSummary.
- Return type
datetime
- property time_execution_started¶
Gets the time_execution_started of this SqlTuningAdvisorTaskSummary. The start time of the task execution.
- Returns
The time_execution_started of this SqlTuningAdvisorTaskSummary.
- Return type
datetime
- property total_sql_statements¶
Gets the total_sql_statements of this SqlTuningAdvisorTaskSummary. The total number of SQL statements related to the SQL Tuning Advisor task.
- Returns
The total_sql_statements of this SqlTuningAdvisorTaskSummary.
- Return type
int