SqlTuningSetSummary¶

class oci.database_management.models.SqlTuningSetSummary(**kwargs)¶

Bases: object

The summary information of a SQL tuning set.

Attributes

`STATUS_BLOCKED`	A constant which can be used with the status property of a SqlTuningSetSummary.
`STATUS_BROKEN`	A constant which can be used with the status property of a SqlTuningSetSummary.
`STATUS_CHAIN_STALLED`	A constant which can be used with the status property of a SqlTuningSetSummary.
`STATUS_COMPLETED`	A constant which can be used with the status property of a SqlTuningSetSummary.
`STATUS_DISABLED`	A constant which can be used with the status property of a SqlTuningSetSummary.
`STATUS_FAILED`	A constant which can be used with the status property of a SqlTuningSetSummary.
`STATUS_REMOTE`	A constant which can be used with the status property of a SqlTuningSetSummary.
`STATUS_RESOURCE_UNAVAILABLE`	A constant which can be used with the status property of a SqlTuningSetSummary.
`STATUS_RETRY_SCHEDULED`	A constant which can be used with the status property of a SqlTuningSetSummary.
`STATUS_RUNNING`	A constant which can be used with the status property of a SqlTuningSetSummary.
`STATUS_SCHEDULED`	A constant which can be used with the status property of a SqlTuningSetSummary.
`STATUS_SUCCEEDED`	A constant which can be used with the status property of a SqlTuningSetSummary.
`description`	Gets the description of this SqlTuningSetSummary.
`error_message`	Gets the error_message of this SqlTuningSetSummary.
`id`	Gets the id of this SqlTuningSetSummary.
`name`	[Required] Gets the name of this SqlTuningSetSummary.
`owner`	[Required] Gets the owner of this SqlTuningSetSummary.
`scheduled_job_name`	Gets the scheduled_job_name of this SqlTuningSetSummary.
`statement_counts`	Gets the statement_counts of this SqlTuningSetSummary.
`status`	Gets the status of this SqlTuningSetSummary.
`time_created`	Gets the time_created of this SqlTuningSetSummary.
`time_last_modified`	Gets the time_last_modified of this SqlTuningSetSummary.

Methods

__init__(**kwargs) Initializes a new SqlTuningSetSummary object with values from keyword arguments.

STATUS_BLOCKED = 'BLOCKED'¶: A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “BLOCKED”

STATUS_BROKEN = 'BROKEN'¶: A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “BROKEN”

STATUS_CHAIN_STALLED = 'CHAIN_STALLED'¶: A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “CHAIN_STALLED”

STATUS_COMPLETED = 'COMPLETED'¶: A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “COMPLETED”

STATUS_DISABLED = 'DISABLED'¶: A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “DISABLED”

STATUS_FAILED = 'FAILED'¶: A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “FAILED”

STATUS_REMOTE = 'REMOTE'¶: A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “REMOTE”

STATUS_RESOURCE_UNAVAILABLE = 'RESOURCE_UNAVAILABLE'¶: A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “RESOURCE_UNAVAILABLE”

STATUS_RETRY_SCHEDULED = 'RETRY_SCHEDULED'¶: A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “RETRY_SCHEDULED”

STATUS_RUNNING = 'RUNNING'¶: A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “RUNNING”

STATUS_SCHEDULED = 'SCHEDULED'¶: A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “SCHEDULED”

STATUS_SUCCEEDED = 'SUCCEEDED'¶: A constant which can be used with the status property of a SqlTuningSetSummary. This constant has a value of “SUCCEEDED”

__init__(**kwargs)¶

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

Parameters:

name (str) – The value to assign to the name property of this SqlTuningSetSummary.
owner (str) – The value to assign to the owner property of this SqlTuningSetSummary.
description (str) – The value to assign to the description property of this SqlTuningSetSummary.
statement_counts (int) – The value to assign to the statement_counts property of this SqlTuningSetSummary.
id (int) – The value to assign to the id property of this SqlTuningSetSummary.
time_created (datetime) – The value to assign to the time_created property of this SqlTuningSetSummary.
time_last_modified (datetime) – The value to assign to the time_last_modified property of this SqlTuningSetSummary.
status (str) – The value to assign to the status property of this SqlTuningSetSummary. Allowed values for this property are: “DISABLED”, “RETRY_SCHEDULED”, “SCHEDULED”, “BLOCKED”, “RUNNING”, “COMPLETED”, “BROKEN”, “FAILED”, “REMOTE”, “RESOURCE_UNAVAILABLE”, “SUCCEEDED”, “CHAIN_STALLED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
scheduled_job_name (str) – The value to assign to the scheduled_job_name property of this SqlTuningSetSummary.
error_message (str) – The value to assign to the error_message property of this SqlTuningSetSummary.

description¶

Gets the description of this SqlTuningSetSummary. The description of the SQL tuning set.

Returns:	The description of this SqlTuningSetSummary.
Return type:	str

error_message¶

Gets the error_message of this SqlTuningSetSummary. Latest execution error of the plsql that was submitted as a scheduler job.

Returns:	The error_message of this SqlTuningSetSummary.
Return type:	str

id¶

Gets the id of this SqlTuningSetSummary. The unique Sql tuning set identifier. This is not OCID.

Returns:	The id of this SqlTuningSetSummary.
Return type:	int

name¶

[Required] Gets the name of this SqlTuningSetSummary. The name of the SQL tuning set.

Returns:	The name of this SqlTuningSetSummary.
Return type:	str

owner¶

[Required] Gets the owner of this SqlTuningSetSummary. The owner of the SQL tuning set.

Returns:	The owner of this SqlTuningSetSummary.
Return type:	str

scheduled_job_name¶

Gets the scheduled_job_name of this SqlTuningSetSummary. Name of the Sql tuning set scheduler job.

Returns:	The scheduled_job_name of this SqlTuningSetSummary.
Return type:	str

statement_counts¶

Gets the statement_counts of this SqlTuningSetSummary. The number of SQL statements in the SQL tuning set.

Returns:	The statement_counts of this SqlTuningSetSummary.
Return type:	int

status¶

Gets the status of this SqlTuningSetSummary. Current status of the Sql tuning set.

Allowed values for this property are: “DISABLED”, “RETRY_SCHEDULED”, “SCHEDULED”, “BLOCKED”, “RUNNING”, “COMPLETED”, “BROKEN”, “FAILED”, “REMOTE”, “RESOURCE_UNAVAILABLE”, “SUCCEEDED”, “CHAIN_STALLED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The status of this SqlTuningSetSummary.
Return type:	str

time_created¶

Gets the time_created of this SqlTuningSetSummary. The created time of the Sql tuning set.

Returns:	The time_created of this SqlTuningSetSummary.
Return type:	datetime

time_last_modified¶

Gets the time_last_modified of this SqlTuningSetSummary. Last modified time of the Sql tuning set.

Returns:	The time_last_modified of this SqlTuningSetSummary.
Return type:	datetime