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.

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