SqlTuningAdvisorTaskSummary

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

Bases: object

The summary for 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. Days to expire the task. 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 task.

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

Gets the instance_id of this SqlTuningAdvisorTaskSummary. The instance id of the task. It 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 task.

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

Gets the owner of this SqlTuningAdvisorTaskSummary. The owner of the task.

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

Gets the recommendation_count of this SqlTuningAdvisorTaskSummary. Number of recommendations produced.

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. Unique identifier of the task. It 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 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. Creation date of the task.

Returns:The time_created of this SqlTuningAdvisorTaskSummary.
Return type:datetime
time_execution_ended

Gets the time_execution_ended of this SqlTuningAdvisorTaskSummary. End timestamp of task execution.

Returns:The time_execution_ended of this SqlTuningAdvisorTaskSummary.
Return type:datetime
time_execution_started

Gets the time_execution_started of this SqlTuningAdvisorTaskSummary. Start timestamp of 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