SqlTuningAdvisorTaskSummaryReportTaskInfo

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

Bases: object

SQL Tuning advisor task general info.

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 SQL Tuning Advisor task description. Not defined on Auto SQL Tuning tasks.

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

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

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

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

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

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

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

Gets the running_time of this SqlTuningAdvisorTaskSummaryReportTaskInfo. The total running time in seconds. Not defined on Auto SQL Tuning tasks.

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

Gets the status of this SqlTuningAdvisorTaskSummaryReportTaskInfo. The SQL Tuning Advisor task status. Not defined on 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. End timestamp of task execution.

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

[Required] Gets the time_started of this SqlTuningAdvisorTaskSummaryReportTaskInfo. Start timestamp of task execution.

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