SqlTuningAdvisorTaskSummary¶

class oci.database_management.models.SqlTuningAdvisorTaskSummary(**kwargs)¶

Bases: object

The summary of a SQL Tuning Advisor task.

Attributes

`TASK_STATUS_COMPLETED`	A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary.
`TASK_STATUS_ERROR`	A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary.
`TASK_STATUS_EXECUTING`	A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary.
`TASK_STATUS_INITIAL`	A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary.
`TASK_STATUS_INTERRUPTED`	A constant which can be used with the task_status property of a SqlTuningAdvisorTaskSummary.
`days_to_expire`	Gets the days_to_expire of this SqlTuningAdvisorTaskSummary.
`description`	Gets the description of this SqlTuningAdvisorTaskSummary.
`instance_id`	Gets the instance_id of this SqlTuningAdvisorTaskSummary.
`name`	Gets the name of this SqlTuningAdvisorTaskSummary.
`owner`	Gets the owner of this SqlTuningAdvisorTaskSummary.
`recommendation_count`	Gets the recommendation_count of this SqlTuningAdvisorTaskSummary.
`sql_tuning_advisor_task_id`	[Required] Gets the sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskSummary.
`task_status`	Gets the task_status of this SqlTuningAdvisorTaskSummary.
`time_created`	Gets the time_created of this SqlTuningAdvisorTaskSummary.
`time_execution_ended`	Gets the time_execution_ended of this SqlTuningAdvisorTaskSummary.
`time_execution_started`	Gets the time_execution_started of this SqlTuningAdvisorTaskSummary.
`total_sql_statements`	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.

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

description¶

Gets the description of this SqlTuningAdvisorTaskSummary. The description of the SQL Tuning Advisor task.

Returns:	The description of this SqlTuningAdvisorTaskSummary.
Return type:	str

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

name¶

Gets the name of this SqlTuningAdvisorTaskSummary. The name of the SQL Tuning Advisor task.

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

owner¶

Gets the owner of this SqlTuningAdvisorTaskSummary. The owner of the SQL Tuning Advisor task.

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

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

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

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

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

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

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

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