SqlTuningAdvisorTaskSummaryReportTaskInfo

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

Bases: object

The general information regarding the SQL Tuning Advisor task.

Attributes

STATUS_COMPLETED A constant which can be used with the status property of a SqlTuningAdvisorTaskSummaryReportTaskInfo.
STATUS_ERROR A constant which can be used with the status property of a SqlTuningAdvisorTaskSummaryReportTaskInfo.
STATUS_EXECUTING A constant which can be used with the status property of a SqlTuningAdvisorTaskSummaryReportTaskInfo.
STATUS_INITIAL A constant which can be used with the status property of a SqlTuningAdvisorTaskSummaryReportTaskInfo.
STATUS_INTERRUPTED A constant which can be used with the status property of a SqlTuningAdvisorTaskSummaryReportTaskInfo.
description Gets the description of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
id [Required] Gets the id of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
name [Required] Gets the name of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
owner [Required] Gets the owner of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
running_time Gets the running_time of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
status Gets the status of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
time_ended [Required] Gets the time_ended of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
time_started [Required] Gets the time_started of this SqlTuningAdvisorTaskSummaryReportTaskInfo.

Methods

__init__(**kwargs) Initializes a new SqlTuningAdvisorTaskSummaryReportTaskInfo object with values from keyword arguments.
STATUS_COMPLETED = 'COMPLETED'

A constant which can be used with the status property of a SqlTuningAdvisorTaskSummaryReportTaskInfo. This constant has a value of “COMPLETED”

STATUS_ERROR = 'ERROR'

A constant which can be used with the status property of a SqlTuningAdvisorTaskSummaryReportTaskInfo. This constant has a value of “ERROR”

STATUS_EXECUTING = 'EXECUTING'

A constant which can be used with the status property of a SqlTuningAdvisorTaskSummaryReportTaskInfo. This constant has a value of “EXECUTING”

STATUS_INITIAL = 'INITIAL'

A constant which can be used with the status property of a SqlTuningAdvisorTaskSummaryReportTaskInfo. This constant has a value of “INITIAL”

STATUS_INTERRUPTED = 'INTERRUPTED'

A constant which can be used with the status property of a SqlTuningAdvisorTaskSummaryReportTaskInfo. This constant has a value of “INTERRUPTED”

__init__(**kwargs)

Initializes a new SqlTuningAdvisorTaskSummaryReportTaskInfo object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:
  • id (int) – The value to assign to the id property of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
  • name (str) – The value to assign to the name property of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
  • description (str) – The value to assign to the description property of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
  • owner (str) – The value to assign to the owner property of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
  • status (str) – The value to assign to the status property of this SqlTuningAdvisorTaskSummaryReportTaskInfo. 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’.
  • time_started (datetime) – The value to assign to the time_started property of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
  • time_ended (datetime) – The value to assign to the time_ended property of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
  • running_time (int) – The value to assign to the running_time property of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
description

Gets the description of this SqlTuningAdvisorTaskSummaryReportTaskInfo. The description of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.

Returns:The description of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
Return type:str
id

[Required] Gets the id of this SqlTuningAdvisorTaskSummaryReportTaskInfo. The ID of the SQL Tuning Advisor task. This is not the OCID.

Returns:The id of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
Return type:int
name

[Required] Gets the name of this SqlTuningAdvisorTaskSummaryReportTaskInfo. The name of the SQL Tuning Advisor task.

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

[Required] Gets the owner of this SqlTuningAdvisorTaskSummaryReportTaskInfo. The owner of the SQL Tuning Advisor task.

Returns:The owner of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
Return type:str
running_time

Gets the running_time of this SqlTuningAdvisorTaskSummaryReportTaskInfo. The total running time in seconds. This is not defined for Auto SQL Tuning tasks.

Returns:The running_time of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
Return type:int
status

Gets the status of this SqlTuningAdvisorTaskSummaryReportTaskInfo. The status of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.

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 status of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
Return type:str
time_ended

[Required] Gets the time_ended of this SqlTuningAdvisorTaskSummaryReportTaskInfo. The end time of the task execution.

Returns:The time_ended of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
Return type:datetime
time_started

[Required] Gets the time_started of this SqlTuningAdvisorTaskSummaryReportTaskInfo. The start time of the task execution.

Returns:The time_started of this SqlTuningAdvisorTaskSummaryReportTaskInfo.
Return type:datetime