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